I need to split out a worksheet into separate files

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

  1. NoITinmyday

    NoITinmyday

    Joined:
    Aug 31, 2011
    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

    Joined:
    Sep 3, 2008
    Likes Received:
    4
    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
    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

    Joined:
    Sep 3, 2008
    Likes Received:
    4
    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
    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. Anon_F

    Windows 7 I need a FREE CD/DVD Burning Software?

    Anon_F, Nov 27, 2009, in forum: Windows
    Replies:
    13
    Views:
    12,340
    captain zed
    Dec 21, 2009
  2. Jaycey

    Outlook How do I import Hotmail folders into my Outlook account?

    Jaycey, Aug 15, 2010, in forum: Microsoft Office
    Replies:
    1
    Views:
    6,052
    Nobody in particular
    Aug 18, 2010
  3. supriyo

    Windows 8 OUT LOOK OBJECT in WINDOWS SERVICE

    supriyo, Jul 1, 2013, in forum: Windows
    Replies:
    1
    Views:
    1,786
    muckshifter
    Jul 1, 2013
  4. V_R
    Replies:
    7
    Views:
    1,162
  5. V_R
    Replies:
    0
    Views:
    562
  6. V_R
    Replies:
    3
    Views:
    415
    muckshifter
    Aug 13, 2015
  7. Joli

    Excel Naming columns in excel worksheet

    Joli, Oct 21, 2015, in forum: Microsoft Office
    Replies:
    1
    Views:
    328
    muckshifter
    Oct 22, 2015
  8. phucmaplun

    Windows 10 Need help. How to play Minecraft on Windows 10

    phucmaplun, Feb 19, 2016, in forum: Windows
    Replies:
    4
    Views:
    526
    Taffycat
    Feb 21, 2016
Loading...