+ Reply to Thread
Results 1 to 4 of 4

Compiling Cell Entries from Multiple Sheets into a New Sheet

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    4

    Compiling Cell Entries from Multiple Sheets into a New Sheet

    Hello everyone.

    I have an Excel workbook that I use to record a set of daily observations. Each day I copy a template worksheet I have and use that copy to log that days observations and repeat. I would like to create a worksheet containing a column of entries that come from a unique cell in each daily worksheet.

    i.e., I would like to know how to use a formula to access the data in another cell in another worksheet, so that I don't each day, have to compile that data by hand. Or at least have a way to use Excel's autocomplete function to do 30ish days worth of observations relatively quickly.

    Attached is a sample workbook that might better explain what I'm trying to achieve. The sheet "Entry1" contains a typical set of entries. I have a workbook containing around 300 or so of these sheets, and I would like to take the contents of cell D3 in each one and populate a list of them on the sheet "Summary" so that I might do statistics on them. I've gathered from a lot of searching that the solution probably involves some combination of the INDIRECT and/or CELL functions, but I am not quite sure how to implement them.

    Thanks,

    tb
    Attached Files Attached Files
    Last edited by tb.west; 12-12-2012 at 12:08 AM.

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Compiling Cell Entries from Multiple Sheets into a New Sheet

    You could try this on the Summary sheet in cell D2:

    =INDIRECT("'"&C2&"'!D3")

    Then you just have to create your sheet list down column C, and fill this formula down column D.

    - Moo
    Last edited by Moo the Dog; 12-11-2012 at 11:40 PM. Reason: Added single-qotes just in case there are spaces in sheet names

  3. #3
    Registered User
    Join Date
    12-11-2012
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Compiling Cell Entries from Multiple Sheets into a New Sheet

    Thank you! That works beautifully.

  4. #4
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Compiling Cell Entries from Multiple Sheets into a New Sheet

    You're welcome. Glad to help.

    - Moo

+ 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