here is what I have been TRYING to do..
I have a directory of excel spreadsheet, each of them are named according to their part number. The all have similar field just with different design values in each field.
I am creating a master spreadsheet to list the material used in each design (let say it is found in cell A1 in each spreadsheet file) I want to link it dynamically to the file so that if I change the design, the master spreadsheet will automatically be updated.
For instance, in my MASTER spreadsheet, I have a column that stores the part number of the design (which is ALSO the name of the file) and I want to be able to use that in my formula to pull the content of any cell in that file. For instance, I have a column of part number from 1 to 10.
1
2
3
4
5
6
On the column right next to it, it has
"='C:[1.xls]Sheet1'!A1" which will look into the spreadsheet 1.xls and grab the content of cell A1. Can I relate the name of the spreadsheet (1.xls in this case) to the cell content to the LEFT of it (which is "1") so that I can "automate or populate" the whole column of data by just pulling the lower right hand corner of the cell and drag it down?
This message was edited by TheBigDog on 2002-08-21 15:39
I have a directory of excel spreadsheet, each of them are named according to their part number. The all have similar field just with different design values in each field.
I am creating a master spreadsheet to list the material used in each design (let say it is found in cell A1 in each spreadsheet file) I want to link it dynamically to the file so that if I change the design, the master spreadsheet will automatically be updated.
For instance, in my MASTER spreadsheet, I have a column that stores the part number of the design (which is ALSO the name of the file) and I want to be able to use that in my formula to pull the content of any cell in that file. For instance, I have a column of part number from 1 to 10.
1
2
3
4
5
6
On the column right next to it, it has
"='C:[1.xls]Sheet1'!A1" which will look into the spreadsheet 1.xls and grab the content of cell A1. Can I relate the name of the spreadsheet (1.xls in this case) to the cell content to the LEFT of it (which is "1") so that I can "automate or populate" the whole column of data by just pulling the lower right hand corner of the cell and drag it down?
This message was edited by TheBigDog on 2002-08-21 15:39