Excel referencing across sheets

  • Thread starter Richard Hocking
  • Start date
R

Richard Hocking

Hi all, I've a conundrum I wonder if anyone can help me with? The situation I
have is a workbook with 2 sheets, call the Sheet A and Sheet B. I have it set
so far so that whatever value I put in a specific cell in Sheet A is
replicated in a specific (but not the same) cell in Sheet B. However, Excel
obviously has a problem if I try to get these two cells to update each other,
ie. I'd like to be able to type the data into EITHER of the cells, and for
the other cell to update the data. (As opposed to always having to type it
into Sheet A). Any ideas please?!

Richard.
 
T

TedMi

Only way I can think of is to enter the data not into a cell, but into a
pop-uo input box which would then write it vi VB into cells in both sheets.
The pop-up could be triggered by a command button on either sheet.
 
Top