I have a workbook named Master.xls which is a master template.
I have workbooks for each month named JanData.xls - Dec.xls
I want to link the data from cell A1 in JanData.xls into cell A1 of
Master.xls which is simple enough.
The link would look like ='[JanData.xls]Sheet1'!$A$1
But what I want to be able to do is replace the [JanData.xls] part of the link
with a cell reference in Master.xls which would be a text entry so that the link
could be changed to read from FebData.xls - MarData.xls etc as desired.
Anyone any Ideas ?
I have workbooks for each month named JanData.xls - Dec.xls
I want to link the data from cell A1 in JanData.xls into cell A1 of
Master.xls which is simple enough.
The link would look like ='[JanData.xls]Sheet1'!$A$1
But what I want to be able to do is replace the [JanData.xls] part of the link
with a cell reference in Master.xls which would be a text entry so that the link
could be changed to read from FebData.xls - MarData.xls etc as desired.
Anyone any Ideas ?