Changed Linked Cell

's Computer Specifications

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?

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
3 option boxes to linked cell-linked cell to be 1,2,3.	Paula	Microsoft Excel Programming	1	29th Oct 2009 01:43 PM
Format changed when the details in cell changed	angel	Microsoft Excel Worksheet Functions	9	15th Jul 2008 12:36 AM
How do I have a linked cell auto-size to fit the linked data?	CristinPDX	Microsoft Excel Misc	2	24th Jun 2008 10:29 PM
linked files to be changed	mohavv	Microsoft Excel Misc	1	19th Nov 2007 04:25 AM
Control Combobox Linked Cell vs Forms Combobox Linked Cell	RamblinWreck	Microsoft Excel Misc	2	26th Mar 2004 03:59 AM