Posted to microsoft.public.excel.misc
|
|
Linking to Summary Tab
You can use indirect
=INDIRECT(A1&"!$D$20")
And copy down
--
Regards Ron de Bruin
http://www.rondebruin.nl
" JS" wrote in message
...
I have a summary tab that is lad out as follows:
Column A Column B
1101
1102
1103
I have individual tabs named 1101, 1102, 1103, etc... This is one field in
each tab (same cell reference D20) that I want to link in the summary. I
know I can click on each tab and do a simple link =+'1001'!D20 - but
wanted
another way - more effecient way using a formula in the summary tab- a
look
up of sorts. Any ideas??
|