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

Closed
Report
Posts
1
Registration date
Wednesday September 16, 2015
Status
Member
Last seen
September 16, 2015
-
Posts
1326
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 28, 2021
-
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

Posts
1326
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 28, 2021
241
Hello Monizuni,

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

Cheerio,
vcoolio.