Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CONCATENATE within links to build different filenames based on for
I have a series of files, all the same layout, where the only difference is
the filename, which is based on the date the file refers to i.e. 'Figures 01 Mar.xls'. Is there away I can build a cell link along the lines of ='C:\DOCS|FIGURES\Figures '&DAY(M26)&' Mar.xls]Sheet 1!$M27? Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Links to other files | Excel Discussion (Misc queries) | |||
HELP!!! Missing Links!!! | New Users to Excel | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |