Hi guys! New to the forum, hoping you'll be able to help me work out a way to do what I'm after. I'm a bit of an Excel noob but I'm making a document with links to all sorts of useful work related stuff like documents, remote desktop PC links etc.
I'm trying to create a hyperlink that can be clicked to open a file that changes name every day by date but I've no idea how. I thought maybe using "=TODAY()" may help in some way, but couldn't see how I'd make that work alongside a hyperlink.
The format of the file I want to open is roughly this:
Daily File - 2016-12-09.xlsx
Appreciate any advice!
Many thanks.
Bookmarks