Excel referencing across sheets
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.
|