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