connecting formulas (not values)

[RZBK]

I am new to the forum so firstly Hi!
I already spent many, many hours uselessly. Please tell me you know the solution ... and that you'll share it with me :-)

I need a function connecting several worksheets with a formula [with values (data) it is easy].

General description:
Folder A has workbook A1.xls (somewhat like a template)
Folder B has workbooks B1.xls through B100.xls
All 101 worksheets have 3 cells in common:
Cells C2, D2, and C3 need =SUM(…:…) formulas.

Example of variables:
A1.xls has 3 Functions:
Cell C2 = SUM(AA2:AZ2)
Cell D2 =SUM(BA2:BZ2)
Cell C3 =SUM(CA2:CZ2)
Now we change A1.xls ranges (variables):
Cell C2 = SUM(AA2:BL2)
Cell D2 =SUM(BM2:CG2)
Cell C3 =SUM(CH2:DD2)

Needed solution is to enter 3 formulas in B1.xls thru B100.xls ONLY ONCE so that the 3 (variable) ranges on A1.xls will automatically show the (variable) A1 formulas (NOT the A1 values)

Equivalent Examples:
Workbook B1.xls can have
Cell C2 = SUM(AA2:AZ2)
Cell D2 =SUM(BA2:BZ2)
Cell C3 =SUM(CA2:CZ2)
OR
Cell C2 = SUM(AA2:BL2)
Cell D2 =SUM(BM2:CG2)
Cell C3 =SUM(CH2:DD2)
OR any A1 formula

Summary: solution needed
Cell C2 = {[(SOLUTION)]} related to ='A1'!$C$2
Cell D2 = {[(SOLUTION)]} related to ='A1'!$D$2
Cell C3 = {[(SOLUTION)]} related to ='A1'!$C$3

I know that changing formulas in a Template will not do the job.

Does somebody have any ideas? I would really appreciate any help. Thank you very much.

[RZBK]

I am new to the forum so firstly Hi!
I already spent many, many hours uselessly. Please tell me you know the solution (and that you'll share it with me :-)

I need a function connecting one worsheet with many worksheets with an "active" formula [not with values, which is easy].

General description:
Folder A has workbook A1.xls (somewhat like a template)
Folder B has workbooks B1.xls through B100.xls
All 101 worksheets have 1 cell in common:
Cell C2
C2 cells need =SUM(…:…) formulas.

Example of variables:
A1.xls has 1 Function:
Cell C2 = SUM(AA2:AZ2)
Now we change A1.xls range (variable):
Cell C2 = SUM(AA2:BB2)

Needed solution is to enter the formula in B1.xls thru B100.xls ONLY ONCE so that the (variable) ranges on A1.xls will automatically show the (variable) A1 formulas (NOT the A1 values) in all in B1.xls thru B100.xls

The connected formula will show/have equivalent examples:
Workbook B1.xls through B100.xls will show/have
Cell C2 = SUM(AA2:AZ2)
OR
Cell C2 = SUM(AA2:BB2)
OR any A1 formula

Summary: solution needed
Cell C2 = {[(SOLUTION)]} related to ='A:A1'!$C$2

I know that changing formulas in a Template will not do the job.
(To copy and paste 100 times the SUMs(…:…) from 'A:A1'!$C$2 into 100 B worksheets is NOT a solution!)

Does somebody have any ideas? I would really appreciate any help. Thank you very much.


P.S. I use Office:Mac 2004

P.S. 2 - I am unable to delete the original post (sorry).