Link to workbooks

S

skoda

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Writing value to another file 2
in over my head 2
Specifying Cells To Copy Across Workbooks Not Working! 11
import =[test.xls]Sheet1!A1 - help 4
Paste active link with a macro 1
Specifying Row to Copy Across ? 5
Select entire rows if between date/time range 3
How to pass value in cell between workbooks ? 1

Top