Steve Swift
Board Regular
- Joined
- Jan 18, 2004
- Messages
- 187
Hi all,
I have a csv which contains a 7 column header row
id number sale commission status Date supplier
As a result of me merging a number of csv's (in dos) and doing some sorting with a macro, I am left with a number of identical rows to this header row at the bottom of the sheet. Can anyone advise me how I can delete those with my macro?
In effect if any other rows exist that are the same as the header row then delete them.
Thanks
Steve
I have a csv which contains a 7 column header row
id number sale commission status Date supplier
As a result of me merging a number of csv's (in dos) and doing some sorting with a macro, I am left with a number of identical rows to this header row at the bottom of the sheet. Can anyone advise me how I can delete those with my macro?
In effect if any other rows exist that are the same as the header row then delete them.
Thanks
Steve