import =[test.xls]Sheet1!A1 - help
The indirect formula allows you to type in any value and use it as a cell (or
range?) reference. For example if you type =A1 into cell C1, whatever you
have typed into A1 will also be in cell C1. if you type ="A"&"1" in cell C1
you literally get "A1" in cell C1. If you enclose that formula in an indirect
statement =INDIRECT("A"&"1") you will once again get whatever was typed into
cell A1. Indirect changes the text "A1" into a cell reference. You can
substitue the value of a cell as a cell reference, for example D1="A1" and
cell C1=indirect(D1) then the value of C1 will be whatever is in A1.
"AMaleThing" wrote:
I'm importing data from .xls reports created each day. The file will
include the date.
Is it possible the file is called "Test 01-05-2008.xls", I could
create a string something like:
=[test +"A3"+ .xls]Sheet1!A1 // Where A3 is 01-05-2008
Help appreciated.
|