Retrieving a specific cell from multiple worksheets

T

TheShaolin

Hello

I've been searching for a couple of hours, and I can't figure this on
out.

Basically, I have pages 1-5. On page 6, I need to reference a specifi
cell. It's the same in all of the first 5 pages, but I can't actuall
reference the page, because they are dumped data, and all my othe
references are off of "bookends" (Placeholders on each end).

The closest tip I found was this one:
Problem:

We want to copy the contents of cell A1 from Sheets1-5 into row 2 o
the current sheet.
That is, cell C2 of the current sheet is to contain the value stored i
cell A1 of Sheet1, cell D2 is to contain the value from Sheet2, and s
on.

Solution:

Use the INDIRECT and COLUMN functions as shown in the followin
formula:
=INDIRECT(\"Sheet\" & COLUMN()-COLUMN($C$2)+1 & \"\'!$A$1\")
Click to expand...

Which would actually work just fine for my purposes, but I cannot ge
the formula to work! Is this because my "sheet" reference is an arra
(between the placeholders)

I can provide more data if my question is unclear. Thank you i
advance for your help :
 
G

ghostwriter

TheShaolin said:
Hello

I've been searching for a couple of hours, and I can't figure this one
out.

Basically, I have pages 1-5. On page 6, I need to reference a specific
cell. It's the same in all of the first 5 pages, but I can't actually
reference the page, because they are dumped data, and all my other
references are off of "bookends" (Placeholders on each end).

The closest tip I found was this one:


Which would actually work just fine for my purposes, but I cannot get
the formula to work! Is this because my "sheet" reference is an array
(between the placeholders)

I can provide more data if my question is unclear. Thank you in
advance for your help :)
Click to expand...

I would write a macro to do the copying, or would standardize the
naming of the other dumped data to allow for the use of references.

I do something very similar in one of my applications but I have a
macro written to open the data file as a seperate file, then copy the
data into a calculations worksheet the crunches the numbers and spits
them out in a standardized format with all of my calculations finished,
then copies that standarized data into a seperate report form. That
lets my use references in the report form for averages and graphs.

Ghostwriter
 
Top