Thanks Daniel for replying. But it is not exactly what I meant.
I am trying to reference to a cell [E11] from mutiple workbooks into this
one worksheet. The purpose of this is to create an index of the
information I
need gathered from other workbooks.
IT IS possible to manually reference each cell. But it becomes way too
time
consuming if the process is repeated with 15 other cells over multiple
workbooks. So the only option I can think of is Autofill.
The file name format stays exactly the same and increases in uniform
sequence.
The location of the workbooks is also the same (D: drive)
IE: TEST1.xls
TEST2.xls
TEST3.xls
Once again:
A1='D:\[TEST1.xls]Sheet1'!$E$11
Outcome should show data from cell "E11" in "Sheet1" in the workbook
"TEST1"
A2='D:\[TEST2.xls]Sheet1'!$E$11
Outcome should show data from cell "E11" in "Sheet1" in the workbook
"TEST2"
A3='D:\[TEST3.xls]Sheet1'!$E$11
Outcome should show data from cell "E11" in "Sheet1" in the workbook
"TEST3"
Hope my explaination wasn't confusing.
Thanks again,
Alfred
Daniel.C said:
In A1, paste :
="'D:\[TEST"&ROW()&".xls]Sheet1'!$E$11"
Copy downwards.
Select the formulae.
Copy, Pastespecial values
Replace :
'D:\[
with :
='D:\[
--
Regards..
Daniel
"Alfred" <
[email protected]> a écrit dans le message de
(e-mail address removed)...
Hi,
I am using excel2007 on XP SP3.
My goal is to use the autofill feature on a certain parameter within my
fomula.
IE:
A1='D:\[TEST1.xls]Sheet1'!$E$11
A2='D:\[TEST2.xls]Sheet1'!$E$11
A3='D:\[TEST3.xls]Sheet1'!$E$11
I only want to file name to change in seqeunce. Location of the file
stays
the same. It's this even possible?
Any comments will be appreciated.
