M
Michael
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.
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.