+ Reply to Thread
Results 1 to 2 of 2

Worksheet call outs

  1. #1
    Registered User
    Join Date
    04-24-2008
    Posts
    2

    Worksheet call outs

    I am attempting to create a summary table worksheet from all the other worksheets within my excel document. i.e. I have a "Summary" worksheet and then a "001", "002", "003"...etc. In one column of my summary worksheet I call out the name of the worksheet that the row refers to. Within this row, for various cells, I want to be able to use that first cell reference (i.e. the name of the worksheet) to have excel find that specific worksheet and then grab a number with the reference specified.

    For example: if I were to write it as a normal function it would be ='001'!C5 and this would find C5 for the worksheet named 001.

    But I want the 001 to be read from the first cell of the row. If we assume A3 of my "Summary" worksheet has a value of 001, then I want to be able to type into a cell in that row something like ='A3'!C5 where A3 would equal 001. But written this way, excel will be looking for the worksheet named "A3".

    Any thoughts on how this function could be written?

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606
    =indirect(a3 & "!c5")

    Don't know if I've changed a setting but everything's gone lower case.

+ 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