hi,
can you help please with VBA to remove any extra empty rows between the tables. and keep a fixed number of row , say 1 row only. so all the vertical separation between tables will be the same.
please check the attached file.
there is actually more than two columns of tables ,but i give sample of two.
highly appreciate you help.
thanks in advance.
Re: Remove duplicates within a defined range
With all respect
How to add link to that post.
Re: Remove duplicates within a defined range
Thank you.
I mean duplicate rows.
If two rows are exactly identical delete one of them
Hi.
How to delete rows in a specific range by VBA
I.e
I want to delete duplicate rows in a table D10:K20.
Table track data
Please help me in coding , my question is clearly explained in the attached excel file.
Re: Track new data
Quote from cytop;778208I would doubt anyone could help with the information you have given. Please take the time to explain your process, what information changes, how, and what information you want to track.
Ideally upload a sample workbook showing a before and after scenario.
[sw]*[/sw]
Please help i uplaoded the sample detailed file
Hi everyone,
Each product has four stages s1 s2 s3 s4
I want to track the stages each product pass through
As per below explanation
Table1(the main table)
Pro1 s1
Table2
Pro1 s1
Table1
Pro1 s2
Table2
Pro1 s1
Pro1 s2
Table1
Pro1 s3
Table2
Pro1 s1
Pro1 s2
Pro1 s3
So table2 track the changes in the product stage.
I think All the coding should be done on table2
Please help
