tintin1012000
Board Regular
- Joined
- Apr 27, 2011
- Messages
- 237
Looking for help,
I have a whole number in A1 which has a whole number validation on it
I need a function that will monitor cell A10.
if A10 changes and then becomes a larger number than A1 then I need to change A1 to match A10
similarly if a user tries too input a figure into A1 which is lower than A10 then automatically change A1 to match A10
thanks all
I have a whole number in A1 which has a whole number validation on it
I need a function that will monitor cell A10.
if A10 changes and then becomes a larger number than A1 then I need to change A1 to match A10
similarly if a user tries too input a figure into A1 which is lower than A10 then automatically change A1 to match A10
thanks all