Calling Data From Matching Workbook Titles.

[sleazyfish]

Hi,

I'm trying to call data from specific workbooks i.e:

I have 48 workbooks all labeled as follows: WK1, WK2, WK3 and so on up to WK48. All of these workbook are in the same layout only the data in the tables vary.

I have a table in a seperate wookbook that extracts the data from the relevant week. For example:

WK41 WK42 WK43 WK44
A 7 3 6 5
B 0 4 8 2
C 1 9 5 1


I would like the data to update manually if I alter the week number in the table header. e.g.

WK43 WK44 WK45 WK46
A 6 5 8 7
B 8 2 4 9
C 5 1 2 3

Is this possible?


Thanks in advance

[rwgrietveld]

The link would look like:

='C:\Documents and Settings\MyDocuments\[WK43.xls]Sheet1'!$A$2

Unfortunately:The INDIRECT function cannot get data from a closed Workbook so

Indirect("'C:\Documents and Settings\MyDocuments\["&$A$1&".xls]Sheet1'!$A$2")

will not work unless the file WK43 is open.

VBA code could easily do the trick.

See this thread: http://www.ozgrid.com/forum/showthread.php?t=12753

[sleazyfish]

Thanks i'll look at that now.