Thread: Use worksheet name in one cell as part of reference in other cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
NBVC[_60_] NBVC[_60_] is offline
external usenet poster
  
Posts: 1
Default Use worksheet name in one cell as part of reference in other cells

Yes, using INDIRECT function..

e.g.

=INDIRECT("'"&A1&"'!B1)

This will extract the value in B1 on the sheet shown by name in cell
A1.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111155

Reply With QuoteReply With Quote