Hello,
I am looking for a way to have cells A1 in sheet1 and A1 in sheet2 always have the same value.
The action would be:
- both are blank
- I enter number 1 in A1 sheet1 --> A1 in sheet2 gets number 1 as well
- I enter letter a in A1 in sheet2 --> A1 in sheet1 changes from 1 to letter a
How could I have it?
I am looking for a way to have cells A1 in sheet1 and A1 in sheet2 always have the same value.
The action would be:
- both are blank
- I enter number 1 in A1 sheet1 --> A1 in sheet2 gets number 1 as well
- I enter letter a in A1 in sheet2 --> A1 in sheet1 changes from 1 to letter a
How could I have it?