Results 1 to 7 of 7

Collation of sheets..how?

This is a discussion on Collation of sheets..how? within the Excel Questions forums, part of the Question Forums category; Hi guys Ok i'm setting up a delay reporting system for products, and it will be someone's duty to report ...

  1. #1
    Board Regular
    Join Date
    Jul 2003
    Posts
    187

    Default Collation of sheets..how?

    Hi guys
    Ok i'm setting up a delay reporting system for products,
    and it will be someone's duty to report on all these delays, and
    so for every delay, he will receive an attached
    spreadsheet, which will be just one row with about 10
    columns on info. He will receive roughly 30-50 a month of these separate sheets via email attachments.
    Now, he needs to take each individual worksheet attached and collate them into one monthly report.

    My question-does excel facilitate the collation of separate worksheets at all ? Or is really the simplest way of gettin the values of these different sheets into one workbook, to cut and paste everything?
    Any help greatly appreciated
    cheers
    olly

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    69,424

    Default Re: Collation of sheets..how?

    You could have a look at Data|Consolidate or Pivot Table|Multiple consolidation ranges.

  3. #3
    Board Regular
    Join Date
    Jul 2003
    Posts
    187

    Default Re: Collation of sheets..how?

    ok, what exactly does consolidate do though? the help files in excel don't seem to shed much light

  4. #4
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    69,424

    Default Re: Collation of sheets..how?

    Well it adds the data up. If you check Create links to source data, Excel creates an outline, which is collapsed to show only subtotals. Beneath that are formulas referencing the source workbook(s). You can remove the outline if you don't need it.

    The best way to see if it does what you want is to try it out on a couple of test workbooks.

  5. #5
    Board Regular
    Join Date
    Jul 2003
    Posts
    187

    Default Re: Collation of sheets..how?

    Ok cool, basically all i need it to do is paste over the values from a separate workbook, or is that best done with a macro ?

  6. #6
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    69,424

    Default Re: Collation of sheets..how?

    Whatever best suits your purpose.

  7. #7
    Board Regular
    Join Date
    Jul 2003
    Posts
    187

    Default Re: Collation of sheets..how?

    ok, cheers for the feedback
    olly

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com