Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
A4:A27 of Sheet 'Iron Man Log' contains hyperlinks to a different cell in Column B of the same sheet.
Assuming this is possible, I'd be grateful for some code for This Workbook that will trigger on Jan 1 every year and will increase all of the row references in this range by 1
e.g.
In 2022 Cell A4 link ref is B32.
On Jan 1 2023 this should change to B33.
On Jan 1 2024 this should change to B34 etc
In 2022 Cell A10 link ref is B74.
On Jan 1 2023 this should change to B75.
On Jan 1 2024 this should change to B76 etc
Many thanks!
A4:A27 of Sheet 'Iron Man Log' contains hyperlinks to a different cell in Column B of the same sheet.
Assuming this is possible, I'd be grateful for some code for This Workbook that will trigger on Jan 1 every year and will increase all of the row references in this range by 1
e.g.
In 2022 Cell A4 link ref is B32.
On Jan 1 2023 this should change to B33.
On Jan 1 2024 this should change to B34 etc
In 2022 Cell A10 link ref is B74.
On Jan 1 2023 this should change to B75.
On Jan 1 2024 this should change to B76 etc
Many thanks!