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