imacauslan
New Member
- Joined
- Oct 6, 2006
- Messages
- 3
I'm having a real problem that I can't quite figure out. I am hoping someone can help me.
I have my "Main" Workbook open, and in it I need to reference a cell value in one -- out of 100 or so -- other Workbooks, each of which has data on a given stock I occasionally follow (e.g., 'IBM.xls', 'MSFT.xls', etc.).
Now to display the value in cell B4, I know can write:
[cell B4:] ='C:\MyStocksToFollow\[IBM.xls]Sheet1'!B4 -- and this will bring in the value from my "IBM.xls" file...
But what I'd really like to do is write the link statement above, not as an absolute reference (to IBM.xls), but with a relative reference to some some other cell's content which I might change at any time (by typing a new stock's name into cell A1, let's say).
So, in "pseudo-code", I'd like to do something like
[cell A1:] "IBM"
[cell B4:] ='C:\MyStocksToFollow\[' + A1 + '.xls]Sheet1'!B4
How can this be accomplished? I'd really appreciate any help! Thanks.
I have my "Main" Workbook open, and in it I need to reference a cell value in one -- out of 100 or so -- other Workbooks, each of which has data on a given stock I occasionally follow (e.g., 'IBM.xls', 'MSFT.xls', etc.).
Now to display the value in cell B4, I know can write:
[cell B4:] ='C:\MyStocksToFollow\[IBM.xls]Sheet1'!B4 -- and this will bring in the value from my "IBM.xls" file...
But what I'd really like to do is write the link statement above, not as an absolute reference (to IBM.xls), but with a relative reference to some some other cell's content which I might change at any time (by typing a new stock's name into cell A1, let's say).
So, in "pseudo-code", I'd like to do something like
[cell A1:] "IBM"
[cell B4:] ='C:\MyStocksToFollow\[' + A1 + '.xls]Sheet1'!B4
How can this be accomplished? I'd really appreciate any help! Thanks.