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

Closed
monizuni Posts 1 Registration date Wednesday September 16, 2015 Status Member Last seen September 16, 2015 - Sep 16, 2015 at 03:02 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Sep 20, 2015 at 09:27 AM
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.
Related:

1 response

vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Sep 20, 2015 at 09:27 AM
Hello Monizuni,

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

Cheerio,
vcoolio.
0