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
1356
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 11, 2022
- 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.

1 reply

vcoolio
Posts
1356
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 11, 2022
250
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