Changed Linked Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA code for pasting links -- modifying RDB code for summary workbook 10
combo box 2
Changing sheet name based on a cell in another sheet 1
Changing Sheet Cell Formula Reference 3
Code to Implement Required Cells Not Working 3
How to change linked source Worksheet 2
sheet event wait for another event? 6
VBA problem. 4

Back
Top