PC Review


Reply
Thread Tools Rate Thread

Changed Linked Cell

 
 
=?Utf-8?B?TWF0dA==?=
Guest
Posts: n/a
 
      18th Jul 2007
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?



 
Reply With Quote
 
 
 
 
=?Utf-8?B?SmltIFRob21saW5zb24=?=
Guest
Posts: n/a
 
      18th Jul 2007
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?
>
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:39 AM.