three-way link between cell values
Posted by Mark on May 22, 2001 11:47 AM
I have a model that I am working on with three worksheets. I want to give the user the ability to enter data in any of the three worksheets and subsequently display the same data in the same cells in the other two worksheets. I cannot use = signs because the user will need to go back and forth between the workbooks and will have to overwrite the cells numerous times. What I am looking for is a macro (or other mechanism) that will recognize when a cell is changed in the workbook and place the value in the same cell in the two worksheet where the cell was not changed. Again the order that the user will put the data in is random.