Thread: Indirect links
View Single Post
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi

See the help for the indirect function
with a sheet name in A1

=INDIRECT($A$1 & "!G3")




--
Regards Ron de Bruin
http://www.rondebruin.nl


"jnix" wrote in message ...
I have a spreadsheet which links to cells in several other worksheets. Is
there a way I can select which worksheet to link to based on information in a
different cell? For instance, I want cell c5 in worksheet A to link to cell
ab4 in the worksheet identified in cell c1 in worksheet A.

Thanks,

jnix