Changed Linked Cell
 

I have a field where the value is linked to another sheet in the workbook.
Is there a way to change the sheet that the field is linked to based on a
another fields value?

Changed Linked Cell
 

Take a look at the Indirect function.

=Indirect("'" & A2 & "'!A1")

Put this formula in cell A3. In Cell A2 type in a sheet name. It will return
the value in cell A1 fo that sheet name...
--
HTH...

Jim Thomlinson


"Matt" wrote:

I have a field where the value is linked to another sheet in the workbook.
Is there a way to change the sheet that the field is linked to based on a
another fields value?