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:

Problem:

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

Solution:

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


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 :)


--
TheShaolin
------------------------------------------------------------------------
TheShaolin's Profile: http://www.excelforum.com/member.php...o&userid=35120
View this thread: http://www.excelforum.com/showthread...hreadid=548743

anyone? anyone? bueller? bueller...?


--
TheShaolin
------------------------------------------------------------------------
TheShaolin's Profile: http://www.excelforum.com/member.php...o&userid=35120
View this thread: http://www.excelforum.com/showthread...hreadid=548743

"Could you repeat that part where you said that stuff about that one
thing"?


--
TheShaolin
------------------------------------------------------------------------
TheShaolin's Profile: http://www.excelforum.com/member.php...o&userid=35120
View this thread: http://www.excelforum.com/showthread...hreadid=548743

a bump a day keeps the homosexuals away.


--
TheShaolin
------------------------------------------------------------------------
TheShaolin's Profile: http://www.excelforum.com/member.php...o&userid=35120
View this thread: http://www.excelforum.com/showthread...hreadid=548743

oh teh noes i have outsmarted everyone


--
TheShaolin
------------------------------------------------------------------------
TheShaolin's Profile: http://www.excelforum.com/member.php...o&userid=35120
View this thread: http://www.excelforum.com/showthread...hreadid=548743

TheShaolin wrote:
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:

Problem:

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

Solution:

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


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 :)

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