griffengm
Industrial
- Jan 12, 2003
- 398
In cell A1 I have a part name e.g. "XXXX". In cell a2 I have another name, "ZZZZ". These also happen to be the names of some workbooks that I wish to reference. In cell d1, I want to reference cell D3 in workbook "XXXX.xls" & in cell D2 reference cell D3 in workbook "ZZZZ.xls".
Is there a way to set up a generic formula in column D that will read the name in column A and use it to reference the appropriate workbook.
I see it looking something like this: "=G:\(folder name)\[(partname from column A).xls]$D$3 where G is drive designator,& folder name is same for all part name workbooks. The formula in d1 will return the value in G:\(folder name)\[XXXX.xls]$D$3, and in d2 returns the value in G:\(folder name)\[ZZZZ.xls]$D$3.
Macro? Text string function?
Griffy
Is there a way to set up a generic formula in column D that will read the name in column A and use it to reference the appropriate workbook.
I see it looking something like this: "=G:\(folder name)\[(partname from column A).xls]$D$3 where G is drive designator,& folder name is same for all part name workbooks. The formula in d1 will return the value in G:\(folder name)\[XXXX.xls]$D$3, and in d2 returns the value in G:\(folder name)\[ZZZZ.xls]$D$3.
Macro? Text string function?
Griffy