+ Reply to Thread
Results 1 to 2 of 2

Copy values from multiple worksheets onto one master sheet

  1. #1
    Registered User
    Join Date
    12-18-2007
    Posts
    1

    Copy values from multiple worksheets onto one master sheet

    Ok I am doing a workbook for my track athletes. Each one has their own worksheet in the workbook. In every I10 cell there is a value that is their average score. I want to Index the scores (so I can rank them) on a master sheet. How can I do this without typing going back and forth copying the destination of the cell into the index.

    I've attached a copy of the workbook. The names of the worksheets are each athlete. The index sheet is where I want everything to go. I started to manually put the first three in there just to show an idea of what I want it to look like. Thank you!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520
    One quick way to frame it up is to use INDIRECT ..

    In your sheet: Index,
    List the cell references in B1 across, viz.: A1, B1, I10
    List the sheetnames in A2 down, viz.: Kentish, Pitts, Hardy, etc

    Then place in B2:
    =IF(COUNTA($A2,B$1)<2,"",INDIRECT("'"&$A2&"'!"&B$1))
    Copy B2 across to D2, fill down as far as required to return the required results from each sheet
    Max
    Singapore

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1