Break master list up into lists in separate worksheets

P

Prashant Rao

I have a list on sheet 1 containing about 8 columns and >3000 records. I'd
like to create a new list on separate worksheets for each value in column C.
While I can filter on Column C (containing the names of the owners of the
business units) in the master list on sheet 1, I need to break up the list so
I can send only the list pertinent to that business owner to him/her.
Filter, Copy and Paste is one option but the thought of doing 45+ times is
not appealing. Any help/advice would be very welcome - something similar to
the PivotTable-Page function which generates a worksheet for each value in
the page field.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deriving several lists from a master list 3
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
Lookup based on list selection in cell 0
Dependent list in excel to create validation 1
Altering Master list / maintain values in worksheets 0
Change drop down list in one cell based on values in other cells 2
Connections with multiple worksheets 0
Referencing Worksheets in separate Workbooks 7

Top