+ Reply to Thread
Results 1 to 7 of 7

Creating a master sheet using data from other sheets in the workbook.

  1. #1
    Registered User
    Join Date
    08-22-2012
    Location
    South africa
    MS-Off Ver
    Excel 2007
    Posts
    14

    Creating a master sheet using data from other sheets in the workbook.

    Hi,

    I have 4 different excel documents with the same set up. I want to have a master sheet on each document that extracts the data from theses sheets to create a summary sheet.

    So for example. i need to extract the persons name, which is always on call B4. then the avearage that is based on data in cell C52. Then the number of assessements which is bacsed on data in C54.

    is there a macro to do this or do i have to just do it manually by going in Cell A1 "=Sheet1!B4" then in cell B2 "=Sheet2!B4" etc.

    bearing in mind there are roughly 150 people whos data i need to summarize.

    Is there a quicker/easier way to reference the values?

    Thanks.
    Last edited by Chaos247; 03-22-2013 at 06:03 AM.

  2. #2
    Registered User
    Join Date
    08-22-2012
    Location
    South africa
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Creating a master sheet using data from other sheets in the workbook.

    I have added an example of the document im using. Just incase my explaination isnt clear. There would be 15 tabs in an average document, with the same setup.

    In the summary i just want to extract the Name(B4), The Average(C52) and The number of assessments(C53)

    Thanks again.
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Creating a master sheet using data from other sheets in the workbook.

    Maybe:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-22-2012
    Location
    South africa
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Creating a master sheet using data from other sheets in the workbook.

    Thank you for your reply.

    I will try to run it and reply soonest.

  5. #5
    Registered User
    Join Date
    08-22-2012
    Location
    South africa
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Creating a master sheet using data from other sheets in the workbook.

    I receive a run error "9 " script out of range.

    I will try and change the ranges and test again.

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Creating a master sheet using data from other sheets in the workbook.

    You need to have a Sheet named "Summary". Or do you want the code to create it?

  7. #7
    Registered User
    Join Date
    08-22-2012
    Location
    South africa
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Creating a master sheet using data from other sheets in the workbook.

    I have created a sheet called "Summary"

    Am i not doing this correctly?

+ 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