Snake Eyes
Board Regular
- Joined
- Dec 14, 2010
- Messages
- 118
- Office Version
- 365
- 2016
- Platform
- Windows
I have a sheet with 20 duplicate sections each representing it's own set of data.
I would like to have
Date Cell: AA68
automatically update with the current date and time (I do know this cell formatting), if any changes are made to
Edit Cells: AA68 or AA71 or AA76.
I'd like to repeat this functionality with the other 19 sections.
What I've found is based on code applied to the sheet and consequently limits this to only one section with limitations in functionality.
Here's the next couple...
Date Cell: AA140
Edit Cells: AA145, AA148, AA153
Date Cell: AA217
Edit Cells: AA22, AA225, AA230
TY
I would like to have
Date Cell: AA68
automatically update with the current date and time (I do know this cell formatting), if any changes are made to
Edit Cells: AA68 or AA71 or AA76.
I'd like to repeat this functionality with the other 19 sections.
What I've found is based on code applied to the sheet and consequently limits this to only one section with limitations in functionality.
Here's the next couple...
Date Cell: AA140
Edit Cells: AA145, AA148, AA153
Date Cell: AA217
Edit Cells: AA22, AA225, AA230
TY