PC Review


Reply
Thread Tools Rate Thread

I need to split out a worksheet into separate files

 
 
New Member
Join Date: Aug 2011
Posts: 10
 
      1st Sep 2011
Hi All
Can someone help me please?
I have a spreadsheet of 16k lines
I need to split that spreadsheet into separate files per manager (column B) so that I can send the manager only their information for review.
There are approx 150 managers listed in column B
I attach an example of what I have and what I would like to see
Thank you all
NoITinmyday
Attached Files
File Type: zip Example2 (2).zip (10.2 KB, 26 views)
 
Reply With Quote
 
 
 
 
Senior Member
Stoneboysteve's Avatar
Join Date: Sep 2008
Location: USA
Posts: 155
 
      2nd Sep 2011
NolTinmyday,

You can use pivot analysis. Just create a pivot table, use managers as a field, select a manager. Add one of the fields to the values, double click the total of values and a separate spreadsheet will be created for the manager you select.

Stoneboysteve
 
Reply With Quote
 
 
 
 
New Member
Join Date: Aug 2011
Posts: 10
 
      2nd Sep 2011
Hi again
I am sure I can rustle up a pivot table use the wizard - however before I start will the seperate spreadsheet show each indivdual company per manager with each individual column of data?
Thanks again
 
Reply With Quote
 
Senior Member
Stoneboysteve's Avatar
Join Date: Sep 2008
Location: USA
Posts: 155
 
      3rd Sep 2011
Hi Again,

I used your data on the attached file. I created a pivot table, sorted the data fields, double clicked the subtotals, and produced individual sheets with all of the information.

You could do this by company as well.

I put notes on each tab in the workbook as well.

Stoneboysteve
Attached Files
File Type: zip Example Reply.zip (18.3 KB, 48 views)
 
Reply With Quote
 
New Member
Join Date: Aug 2011
Posts: 10
 
      6th Sep 2011
Hi Stoneboysteve
Thanks for yoru replies to both my threads. Both threads are to do with the same monthly piece of work so are very helpful. I have been using the record macro function as well but have no idea how to save the macro I create or then go in and edit it, as I get so far, get sidetracked and then do not know how to go back to the same macro to carry on the recording. The book I have ordered should help me with the very basics but I am definitely am up for learning. I suppose ideally what I would like to do is amalgamate both pieces of work so that it identifies duplicates, concatenate the names, totals the amounts, then removes one (or more) of the duplicates and then creates a separate spreadsheet for each manager with the data. I would like to have a play around with your suggestions on this thread and the other one as I did some macro work yesterday but it is very basic.
I did also find a macro someone had written in the forum for a person who wanted to achieve the same result I did and applied it to a test spreadsheet and it created separate files per manager. I reviewed those files and they looked spot on so I may have the macro to create the files, just need to finalise the other thread regarding the duplicates
 
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
split worksheet after empty row into separate workbooks Marylu Microsoft Excel Programming 3 6th Nov 2009 10:19 AM
Separate worksheet in separate workbook as macro dranon Microsoft Excel Discussion 5 3rd May 2009 03:41 AM
Split 9 weeks of data on a worksheet into 9 separate worksheets BeSmart Microsoft Excel Programming 1 5th Nov 2008 01:15 AM
Split an Excel file into separate files kmrtx Microsoft Excel Programming 3 14th Oct 2008 07:36 PM
how to separate .doc and .docx files into separate folders JOHN Microsoft Word New Users 2 28th Mar 2008 12:10 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:50 PM.