Interactive Calendar for Daily Reports

[jsmith1692]

Hi,

I want an easy way to access daily reports using a calendar as a dashboard. I have already created the calendar in Excel which runs from 2018 and 5 further years to future proof the document. On a separate tab I have created the Hyperlinks for every daily report for the next 5 years so that (As long as the path and file names are maintained) the documents are linked to the spreadsheet.

I have got this far and now don't want to do the tedious task of linking each cell that represents a day to the correct hyperlink. There are nearly 2000 links so I really don't have the time or patience to do this. I know this would be easy if the dates were all down a single column but I want to maintain the look of a traditional calendar you would find on any computer or phone.

If anyone has any ideas or tried and test solutions I would be very grateful.

Thanks!

 

[Warship]

without knowing way more about what you have already built and how it is put together, it is very difficult to propose a viable solution.
you likely do not need to link each Calendar Day's Cell to its respective Reports.
you can probably use Right-Click and/or Double-Click Events on the Calendar Sheet(s) with some type of search to locate and/or process the Reports.