Link to workbooks
 

FIRST Regards to the group!

Now question :-) is there a way to do this from below. I have 10 workbooks
named 01.xls - 10.xls. They are identical only numbers and month name are
different. Now I have summary that gets data from them. Summary has
something like this A1 =[1.xls]Sheet1!A1, B1 = [2.xls]Sheet1!A1 ...

Now if I want to add 11.xls a need to edit all values in link from 10.xls
to 11.xls. Is there a way to lets do something like this:

A B
0 JAN/06 FEB/06
1 1 2
2 =[A1.xls]Sheet1!A1 =[B1.xls]Sheet1!A1
3 =[A1.xls]Sheet2!A1 =[B1.xls]Sheet2!A1
4 =SUM(A2:A3) =SUM(B2:B3)
..
..
..

Like this I can fill rows when some new xls file appear.

Thanks in advance guys...

Link to workbooks
 

=Indirect("[" & A$1 & ".xls]Sheet" & row(A1) & "!A1")

Possibly

--
Regards,
Tom Ogilvy



"skoda" wrote:

FIRST Regards to the group!

Now question :-) is there a way to do this from below. I have 10 workbooks
named 01.xls - 10.xls. They are identical only numbers and month name are
different. Now I have summary that gets data from them. Summary has
something like this A1 =[1.xls]Sheet1!A1, B1 = [2.xls]Sheet1!A1 ...

Now if I want to add 11.xls a need to edit all values in link from 10.xls
to 11.xls. Is there a way to lets do something like this:

A B
0 JAN/06 FEB/06
1 1 2
2 =[A1.xls]Sheet1!A1 =[B1.xls]Sheet1!A1
3 =[A1.xls]Sheet2!A1 =[B1.xls]Sheet2!A1
4 =SUM(A2:A3) =SUM(B2:B3)
..
..
..

Like this I can fill rows when some new xls file appear.

Thanks in advance guys...

Link to workbooks
 

On Wed, 15 Nov 2006 13:14:02 -0800, Tom Ogilvy wrote:

=Indirect("[" & A$1 & ".xls]Sheet" & row(A1) & "!A1")

Possibly

Hmmmm, that could do it. BIG THANKS man! :D