Export chunks of data into new workbooks

Hi all,

I have one big master file with tons of cost data broken down by the type of cost. I need to have a separate workbook for each type of cost and rather than filter copy a million times into new workbooks, I'd like to build a macro that does it.

I have attached a sample worksheet just to get the format across. So in this sample the macro would create separate workbooks for all rows associated with each cost type (100, 101, 102, and 103).

The actual data sets are much larger or I would just do it manually.

Let me know if there's any other information I can give you to help.

Thanks,
Scott

Hi sokeefe14

This Code is in the attached...CTRL + x will fire the Code. The newly created Files are in the same Folder as the Sample File.

Please Login or Register  to view this content.

Glad you got it sorted...thanks for the Rep...