Automatically changing link. How?
I use a template to make a report every month in Excel. The naming convention
I use is €ś2006MarSwimware€ť for the March 2006 Swimware report we send to the
OhioEPA. I do not make a years worth of blank reports in advance for good
reasons I dont need to get into here. Now, what Id like to be able to do is
put a link to a particular cell in the previous months report on the
template that would automatically rename itself. I tried combing text and a
link to the month-1 on the current report but instead of getting
€ś2006MarSwimware€ť I get €ś'[200638807Swimware.xls]DATA - Cover'!$C$3. Am I
attempting the impossible? (The link that produced this is
="'[2006"&(K2)&"Swimware.xls]DATA - Cover'!$C$3" Where K2 is a link to a cell
with the formula =C4-1 that returns €śMar€ť and C4 is the date 4-01-2006.)
|