Bryan Hessey Wrote:
=INDIRECT("sheet"&ROW()&"!A1")
and formula-drag down the column for 130 rows
Brian
Thanks for this, this only seems to work if the worksheets are called
sheet1 sheet2 etc, how does this need to change if the sheets have
different names?
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread:
http://www.excelforum.com/showthread...hreadid=392061