Consolidate data

[Gizmo]

Hi guys,

I come back with one problem I face right now:

Suppose I link my cells "A1" and "B1" to the cells in other workbooks.
A1 ='K:\2004\01\[Germany_Data.xls]Summary'!$D$26
B1 ='K:\2004\02\[Germany_Data.xls]Summary'!$D$26

where "01" stands for January, "02" for February etc...

How should I proceed if I would like to extend it automatically to get in
the following columns the data for next months (March in "C1", April in
"D1") for the same cell (i.e. $D$26)?

Any simple solutions?
Any complex solutions ?

Thanks for any help on this!

Gizmo

 

[Frank Kabel]

Hi
one way:
- download the free add-in Morefunc.xll
(http://longre.free.fr/english/)
- use the following formula in A1:
=INDIRECT.EXT("'K:\2004\" & TEXT(ROW(1:1),"00")
& "\[Germany_Data.xls]Summary'!$D$26")
and copy down