| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to stop formuls from automatically changing | Excel Discussion (Misc queries) | |||
| Link pictures in Excel 2003 doesn't work! | Excel Discussion (Misc queries) | |||
| Automatically changing colors | Excel Discussion (Misc queries) | |||
| How do I automatically calculate YTD numbers by changing a date? | Excel Worksheet Functions | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
Threaded Mode
