marklancer
New Member
- Joined
- Oct 7, 2002
- Messages
- 1
I'll try my best to explain the situation and hopfully someone will have an answer.
I want to retrieve the value of a cell from another sheet and/or workbook based on the cell value specific cell.
For example in the function:
=[test.xls]Sheet1!A1
I would like to define either [test.xls] or Sheet1 using the value of a cell within the current workbook.
Thanks in advance.
-Mark
I want to retrieve the value of a cell from another sheet and/or workbook based on the cell value specific cell.
For example in the function:
=[test.xls]Sheet1!A1
I would like to define either [test.xls] or Sheet1 using the value of a cell within the current workbook.
Thanks in advance.
-Mark