PC Review


Reply
Thread Tools Rate Thread

Break master list up into lists in separate worksheets

 
 
=?Utf-8?B?UHJhc2hhbnQgUmFv?=
Guest
Posts: n/a
 
      20th Sep 2007
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Totaling cells from separate worksheets to master form snake941 Microsoft Excel Misc 1 22nd Apr 2010 01:13 AM
compare and merge lists in separate worksheets EAH Microsoft Excel Worksheet Functions 1 7th Mar 2008 05:03 AM
how do I generate lists in worksheets based on a master list works =?Utf-8?B?RnVybG9uZw==?= Microsoft Excel Worksheet Functions 10 15th Jul 2007 09:36 AM
Need help comparing & flagging email lists in separate worksheets theirieone@gmail.com Microsoft Excel Programming 5 18th Jan 2007 11:40 PM
Filter Master Worksheet and Populate Separate Worksheets alex richardson Microsoft Excel Misc 1 4th Oct 2004 04:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:52 AM.