Copy multiple rows that contain a certain "name" in column "A" then paste it into new work

Good day all,

I am looking for help with a VBA code. I have a raw data sheet labeled "Raw Data" that has departments labeled in columns "A" and other data in columns B:J (Dates, Numbers, etc.). I want to copy all department rows that meet a certain criteria to another workbook. For example, In my "Raw Data" sheet I have several departments listed in column "A" which include "Shipping", "Receiving", "Tech Support", etc. They all appear in Column "A" in multiple and random places (they are not in order). I want to write code to copy any and all rows that contains "Shipping" in column "A" to a new new work book labeled "Shipping" and then copy any and all rows that contain "Receiving" in column "A" to a new workbook labeled "Receiving" and so on for "Tech Support" and the other departments we have. I have over 6000 rows of data and 12 different departments. I want to take the data dump "Raw Data" and sned the different departmental data to their own respective workbook that I can analyze form there. Thank you in advance for you support!

Rob

Hi
You could use the Advanced Filter and copy the filtered rows to a new worksheet.
Hope this helps.
Tony

Does this help?

Please Login or Register  to view this content.

Great idea, Tony. Thank you!

Rob

You're welcome. Glad to help out, and thanks for the feedback.