cell reference in another workbook

[Guest]

I have 12 monthly workbooks with one section that summarises the data for the
month into about 10 sections. So, in the summary I have about 10 rows, with
basic formula
B100=sum(B2:B10)
B101=sum(B11:B20) and so on.

I have another workbook for the year that references the cells in the summary

My question is, if I have both the workbooks open(current month and year),
and I insert a new row, the summary will change to B101=sum(B2:B10) and the
reference in the yearly workbook will be updated as well.
If the yearly workbook is closed, and I insert a new row into the current
month, the refernce will not update in the yearly workbook, it will still try
to reference B100

Do both workbooks have to be open?

 

[JE McGimpsey]

Yes, unless you're using a named range.

 

[Guest]

Could I use a formula to look at a cell next to it and then return based on
the text inside that cell?

ie: if A100 = "Group A", return contents of B100.

 

[Bob Phillips]

Why not just use named ranges as JE suggests?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)