Deleting multiple rows of data

I've been trying for some time but have not been able to get the right code to do what I need. I have a data file with multiple rows of data for multiple parts. This file gets to me as a csv. file. (see attatchment) I had something similar that I found here and was able to tweek to fit my needs, but it was for a sheet that only contained data for a single file on the worksheet (part of code below). The macro I need know has to work on a sheet with multiple parts (see attatchment for example of worksheet).

Please Login or Register  to view this content.

Hello Leal72,

Can you give an example of the data you want to keep and what you deleted? Will the worksheet data be stored in separate files?

Sincerely,
Leith Ross

I've attatched a workbook that has the file the way I receive it and the next sheet has it reduced.

Hello Leal72,

Thanks for taking the time to do that. I downloaded your file, and it is clear what you want to do. I'll work on this and post back.

Sincerely,
Leith Ross

Hello Leith Ross

Thanks for taking the time to look at this. Was wondering if you were able to come up with anything.

thanks

Hi,
This procedure will output the result into Sheets("AFTER") and you can change the names to fit your needs. I don't think it's the most efficient way to do it, but it should get the job done!

Please Login or Register  to view this content.

Good Luck!
Tony