I need to split out a worksheet into separate files

Discussion in 'Windows 7' started by NoITinmyday, Sep 1, 2011.

  1. NoITinmyday

    NoITinmyday

    Joined:
    Aug 31, 2011
    Messages:
    10
    Likes Received:
    0
    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:

    NoITinmyday, Sep 1, 2011
    #1
    1. Advertisements

  2. NoITinmyday

    Stoneboysteve VIP Member

    Joined:
    Sep 3, 2008
    Messages:
    161
    Likes Received:
    0
    Location:
    USA
    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
     
    Stoneboysteve, Sep 2, 2011
    #2
    1. Advertisements

  3. NoITinmyday

    NoITinmyday

    Joined:
    Aug 31, 2011
    Messages:
    10
    Likes Received:
    0
    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
     
    NoITinmyday, Sep 2, 2011
    #3
  4. NoITinmyday

    Stoneboysteve VIP Member

    Joined:
    Sep 3, 2008
    Messages:
    161
    Likes Received:
    0
    Location:
    USA
    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:

    Stoneboysteve, Sep 3, 2011
    #4
  5. NoITinmyday

    NoITinmyday

    Joined:
    Aug 31, 2011
    Messages:
    10
    Likes Received:
    0
    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
     
    NoITinmyday, Sep 6, 2011
    #5
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. feckit
    Replies:
    13
    Views:
    12,153
    captain zed
    Dec 21, 2009
  2. Jaycey
    Replies:
    1
    Views:
    5,806
    Nobody in particular
    Aug 18, 2010
  3. Mrbatburn

    Wizran.dll error at startup, need help

    Mrbatburn, May 30, 2011, in forum: Windows 7
    Replies:
    4
    Views:
    1,611
    kristain
    Jun 6, 2011
  4. David92595

    need a quick script

    David92595, Jul 8, 2011, in forum: Windows 7
    Replies:
    0
    Views:
    922
    David92595
    Jul 8, 2011
  5. feckit

    Stopping PC going into standby

    feckit, Oct 14, 2011, in forum: Windows 7
    Replies:
    3
    Views:
    1,387
    uganr
    Dec 29, 2011
Loading...

Share This Page