Hi
I have a set of data with dates across the columns for each day going for a whole year for example
In the first columns I want to put today's date for example 18-Mar-19, then i want to hyperlink that so it goes to the correct column in Excel which could be for example column ZG, cell reference doesn't matter too much can be "ZG3"as an example.
I can't get the hyperlink to be dynamic, ideally I want to use the Today() formula and the excel hyperlink moves 1 column as each day passes....
Let me know if an example helps!
Cheers
I have a set of data with dates across the columns for each day going for a whole year for example
In the first columns I want to put today's date for example 18-Mar-19, then i want to hyperlink that so it goes to the correct column in Excel which could be for example column ZG, cell reference doesn't matter too much can be "ZG3"as an example.
I can't get the hyperlink to be dynamic, ideally I want to use the Today() formula and the excel hyperlink moves 1 column as each day passes....
Let me know if an example helps!
Cheers