View Single Post
  #1   Report Post  
Paul Sheppard
 
Posts: n/a
Default Links to multiple Worksheets


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


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