retrieve value in file (NO VBA)
Hi,
In cell A1 of summary.xls, I need to retrieve the value of cells A1 of the
file with name in cells B1 of summary.xls.
Ex.
In A1 of summary.xls
='C:\[a.xls]Foglio1'!$A$1
I need to insert the namefile in B1 of summary.xls
--- 'C:\[ ** value of cells B1 ** ]Foglio1'!$A$1
Thanks in advance to anyone
M
|