Thread: Insert a cell value into a link to another worksheet.
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Insert a cell value into a link to another worksheet.
Sheeloo wrote...
Try INDIRECT...
....
eg
=Sheet1!A1
can be replaced by
=INDIRECT("Sheet1!A" & B1)
where B1 contains 1
....

Or avoid inefficient volatile functions and use

=INDEX(Sheet1!$A:$A,B1)
Reply With QuoteReply With Quote