Brightspark98
Board Regular
- Joined
- Oct 31, 2009
- Messages
- 74
Bear with me!! I think I am explaining what I need to know.....
Lets say we have several workbooks named -Premier, Championship, First, Second. And each of those workbooks has sheets called League, Players, Results.
If I enter Premier in cell A1 in a further work book, and League, in cell A2 in the same book. How can I get a link in cell A3 populated from the contents of cells A1 & A2?
e.g.
<table border="0" cellpadding="0" cellspacing="0" height="63" width="496"><colgroup><col width="116"></colgroup><tbody><tr height="20"> <td class="xl65" style="height:15.0pt;width:87pt" height="20" width="116">='C:\\Documents\Sports Directory\[Premier.xls]League'!$A1</td> </tr></tbody></table>
The A1 is the cell location required in the workbook location.
Hope this makes sense..
I would like to do this using excel functions only if possible.
Thanks in advance..
Excel 2007
Lets say we have several workbooks named -Premier, Championship, First, Second. And each of those workbooks has sheets called League, Players, Results.
If I enter Premier in cell A1 in a further work book, and League, in cell A2 in the same book. How can I get a link in cell A3 populated from the contents of cells A1 & A2?
e.g.
<table border="0" cellpadding="0" cellspacing="0" height="63" width="496"><colgroup><col width="116"></colgroup><tbody><tr height="20"> <td class="xl65" style="height:15.0pt;width:87pt" height="20" width="116">='C:\\Documents\Sports Directory\[Premier.xls]League'!$A1</td> </tr></tbody></table>
The A1 is the cell location required in the workbook location.
Hope this makes sense..
I would like to do this using excel functions only if possible.
Thanks in advance..
Excel 2007
