Date change to Change table data ??

[davehazle]

I have 2 fields with different dates in a spreadsheet. Under these dates I have values pulled from a Worksheet with the same name as the corresponding date .
eg.
..............A..................................B.............C
row1 10-27-05......................11-03-05
row2..='10-27-05'!B$4............='11-03-05'!B$4
row3..='10-27-05'!B$16..........='11-03-05'!B$16
row4..='10-27-05'!B$30..........='11-03-05'!B$30
row5..='10-27-05'!B$46..........='11-03-05'!B$46

Is there any way to Change the Date in Row 1 :Column A or B and have the rest of the data in the Tables below change along with it?

Thanks for all the help this forum has provided me. It is quite possibly the best resource for Excel on the web. Largly due to the wonderful people who reside here.


Dave

 

[Norie]

You could use INDIRECT.

=INDIRECT("'" & A1 & "'!B$4")
=INDIRECT("'" & A1 & "'!B$16")
etc

 

[davehazle]

Than you very much for the reply. I was not aware of the indirect formula...
any way you could help me out with this one?

http://www.mrexcel.com/board2/viewtopic.php?p=856430#856430