| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable file reference
I am trying to use a date field in a column header to point to a file name to
pull data from and cannot get the formula to execute. Example: B2 =10/2/08 B3=10/3/08 B4=10/4/08 ... etc.... formula in B3 = "=CONCATENATE("='Report ",MONTH(GL$3)&"-"&DAY(GL$3)&"-"&YEAR(GL$3),".xls'!Data" where the report is stored as "Report 10-2-08.xls" and referencing the named field "Data". If I hard code the line the formula works and the Data appears in B3 but the above line only shows the text in the cell and not the data referenced. What am I doing wrong? Thanks in advance for your efforts. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a linked file based on variable location reference | Excel Discussion (Misc queries) | |||
| vba variable value via cell reference | Excel Discussion (Misc queries) | |||
| How to use variable in reference | Excel Worksheet Functions | |||
| Making a file and worksheet reference into a variable.... | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Threaded Mode
