How to remove unwanted rows

[Steve Swift]

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

 

[Jonmo1]

and doing some sorting with a macro

I think it may end up being easier fixing that macro so it doesn't do that...

Can you post the code to that macro ?

 

[Steve Swift]

Hi,

The macro is not what is causing the extra headers they are coming form merging the csv's using dos. I am simply unable to find a way to merge the csvs together in excel so an easy solution is dos using

copy *.csv merge.csv

gives me a single csv with all the content of every csv in the folder. As a result if there are 10 csv's I get 10 header rows. I sort by date with my macro and keep the top header row which puts all the other header rows at the bottom of the sheet.

If I could make a merge of all these csvs work in excel I'd do it that way but I cannot

Steve

 

[Jonmo1]

What collumn has your dates?
And are they VALID Excel Dates ? - To test, put this formula anywhere
=ISNUMBER(A1) where A1 is a cell with one of those dates..

TRUE or FALSE?

 

[Steve Swift]

Column F = TRUE

 

[Jonmo1]

Try this..assuming the header of column F is TEXT and not a number...

'This will find the LAST Date in column F
x = Application.Match(9.99999999999999E+307, Range("F:F"))

'This will delete everything past that
Range(x + 1 & ":65536").EntireRow.Delete


Hope this helps...

 

[Steve Swift]

Hi Jonmo,

PERFECT

Thanks for your help. very much appreciated.

Steve