dynamically link cells

[cloughna]

I apologize if this has already been posted.

I am trying to dynamically link two cells, and I don't think equations will do. Essentially, I am trying to acheive the following

When I enter a value in Sheet1!A1, I want it to reflect in Sheet2!A1
When I enter a value in Sheet2!A1, I want it to reflect in Sheet1!A1.

The application is that I create a List of Values on Sheet1. On Sheet2 I have a bunch of analyses that use vlookup to pull the data from Sheet1.

The problem is that if I want to change some of the values in my List of Values, I can't do it while I'm working on the analyses (which are on Sheet2). Instead I have to switch sheets, find the value, and change it.

In this particular application that's a problem. Any help (or requests for clarification) are greatly appreciated.

 

[drsarao]

Why do you need the same data to be in two different places?

There are 2 ways that I know of:
Group Sheet1 and Sheet2. Select sheet1 and then Ctrl+click sheet2.
Now whatever you enter in sheet1 will also go to sheet2 in the same cell and vice versa.
The grouping will remain in effect only as long as you are flipping back and forth between sheet1 and 2. If you click any other sheet then 1 and 2 will ungroup.

Second way is to use macro(VBA) in Worksheet_Change event of sheet1 and 2. It checks to see if there is any change in column A and then copy it across to the other sheet.

 

[cloughna]

Would the worksheet.change function work even if I wanted the cells on sheet1 to be different?

For example, If I wanted cell J5 on Sheet1 to correlate to B26 on Sheet2?