=INDIRECT("sheet"&ROW()&"!A1")
and formula-drag down the column for 130 rows
Paul Sheppard Wrote:
I have a workbook (Excel2000) with 130+ worksheets, I want to create a
Master worksheet with a link to cell A1 of each worksheet in column A
of the master worksheet
eg. in the the master cell A1 is linked to cell A1 Sheet1, A2 is linked
to cell A1 Sheet2 etc
Is there a quick way to do this or do I have to create each link
separately
Thanks
Paul
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=392061