Macro to copy rows of data off of a sheet into several different

Closed
monizuni Posts 1 Registration date Wednesday 16 September 2015 Status Member Last seen 16 September 2015 - 16 Sep 2015 à 15:02
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 20 Sep 2015 à 09:27
Hello, i'm new to these forums and new to writing macros, I've been trying to find a solution to my problem but haven't found one yet.

I need a macro to copy rows of data off of a sheet into several different worksheets. I have a worksheet with columns A-O. The criteria in Column E are different departments, i need a macro that copies all the rows for each department and puts them in individual worksheets. For instance column G has Departments "000", "GEN", "CCM", "HRS" and others. I need it to copy all the rows with 000 and put them in a new worksheet and save it, and then go to the next one GEN and do the same and so on and so forth.

1 response

vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 262
20 Sep 2015 à 09:27
Hello Monizuni,

Do you still need help with your query or have you sorted it all out?

Cheerio,
vcoolio.