I am trying to link the same cells with different workbooks. I want to be able to only have to change the link for the workbook, and leave the cell references the same.
I could put in: ='c:\database[file1.xls]Sheet1'!C15
for each cell, that works.
but I want to reference different files; file1, file2, file3 etc.
This is what i've got so far
A1='c:\database[file1.xls]sheet1'
A2=!C15
A3=!C16
A4=!C17
B1='c:\database[file2.xls]sheet1'
B2=!C15
B3=!C16
B4=!C17
I hope this makes sence...
Any help would be great!!!
Thanks
spiva
I could put in: ='c:\database[file1.xls]Sheet1'!C15
for each cell, that works.
but I want to reference different files; file1, file2, file3 etc.
This is what i've got so far
A1='c:\database[file1.xls]sheet1'
A2=!C15
A3=!C16
A4=!C17
B1='c:\database[file2.xls]sheet1'
B2=!C15
B3=!C16
B4=!C17
I hope this makes sence...
Any help would be great!!!
Thanks
spiva