maclachlan19
Board Regular
- Joined
- Jul 8, 2013
- Messages
- 53
I have 3 sheets, on each of the sheets the user inserts a date in Cell B1.
I need all 3 dates to be the same at all times. So if B1 is changed on Sheet1, it needs to be duplicated on Sheet 2 and 3 in the same B1 cell.
I'm not sure how to do this as I can't use a simple formula because the user is going to be typing over the contents of the cell and the formula would get erased.
I need all 3 dates to be the same at all times. So if B1 is changed on Sheet1, it needs to be duplicated on Sheet 2 and 3 in the same B1 cell.
I'm not sure how to do this as I can't use a simple formula because the user is going to be typing over the contents of the cell and the formula would get erased.