Dynamic Hyperlink Linked to Changing Cell Value??

[jdowski]

Hi Excel Experts,

I have a spreadsheet where I enter data. At one point I have to open up another spreadsheet that is created every month named
mmyy.xls with the mm representing the previous month. I don't want to link to a cell in this spreadsheet, (too many users to be accurate long term) I just want the hyperlink to open the spreadsheet. I can write a formula with logic to give me a text string that will match the file name I want every month but I don't think I can just paste it into the hyperlink setup screen. This kind of reminds me of "dynamic chart titles" but I think it's different.

Can this be done

 

[Ian Mac]

You can use the HYPERLINK function,

if A1 contains a date mmyy e.g. 0402
you can use:

=HYPERLINK("D:Misc"&TEXT(A1,"0000")&".xls","Open Book "&TEXT(A1,"0000"))

the second arguement is the friendly name you want to give to it. i.e. the name in the cell.

Hope this helps.

 

[jdowski]

Thanks Ian!!

It worked just like I hoped it would....

You Da Man !!!!

Joe Dowski
Woodbury, CT. USA