scotthannaford1973
Board Regular
- Joined
- Sep 27, 2017
- Messages
- 114
- Office Version
- 2010
- Platform
- Windows
Hi all
I have a sheet with data in B2:O2 that dynamically links to another sheet (B2:O2 basically summarises data from elsewhere).
I would like, in A2, to put the latest date of when any of the cells in range B2:O2 change. The only code I have found puts the date into offset columns - which is no good as that would depend on which cell changes... I want the date to be added only to A2 when any of B2:O2 change.
thanks in advance!
I have a sheet with data in B2:O2 that dynamically links to another sheet (B2:O2 basically summarises data from elsewhere).
I would like, in A2, to put the latest date of when any of the cells in range B2:O2 change. The only code I have found puts the date into offset columns - which is no good as that would depend on which cell changes... I want the date to be added only to A2 when any of B2:O2 change.
thanks in advance!