Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Aug 2003
    Location
    Lake Forest, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Create a Summary Page (2000)

    Hi! I have a template budget that I send to suppliers to complete costs for specific line items. I receive several bids from different suppliers and I am trying to create a summary spreadsheet of all of them once they come in. Currently, I key in the numbers manually into the summary spreadsheet. Is there a way for me to have excel populate the fields for me in a summary once I have copied each supplier sheet into one workbook? I've attached my spreadsheet below for reference. Your help would be GREATLY appreciated! <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Create a Summary Page (2000)

    In cell J6 on the Summary sheet, enter the formula <code>=A!R6</code>. You can then copy this formula to J7:J10 and to J16:J21. Similar for the others.

    The attached version shows a slighty different approach. I unmerged the cells in column J, and entered the following formula in J6:
    <code>
    =INDIRECT(J$5&"!R"&ROW())
    </code>
    and filled right to L6, then down to L10. NEx, I copied the formula to J16:L21.

  3. #3
    Lounger
    Join Date
    Aug 2003
    Location
    Lake Forest, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create a Summary Page (2000)

    Thanks, Hans - that works great! When I have a set of new budgets, is there a way for me to summarize them on the summary worksheet without having to re-input the formulas?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Create a Summary Page (2000)

    If you use the INDIRECT formulas as in the workbook I attached, all you need to do if you add more sheets, is to add their names in the summary sheet in M6, N6 etc., and fill the formulas to the right, or copy/paste them. They will work for the new budgets without alteration.

  5. #5
    Lounger
    Join Date
    Aug 2003
    Location
    Lake Forest, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create a Summary Page (2000)

    Thanks, Hans. I really appreciate all of your help!

Posting Permissions

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