software

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?Yes, unless you're using a named range.

In article gt;,
Corben gt; wrote:

gt; Do both workbooks have to be open?

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 = quot;Group Aquot;, return contents of B100.

quot;JE McGimpseyquot; wrote:

gt; Yes, unless you're using a named range.
gt;
gt; In article gt;,
gt; Corben gt; wrote:
gt;
gt; gt; Do both workbooks have to be open?
gt;

Why not just use named ranges as JE suggests?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Corbenquot; gt; wrote in message
...
gt; Could I use a formula to look at a cell next to it and then return based
on
gt; the text inside that cell?
gt;
gt; ie: if A100 = quot;Group Aquot;, return contents of B100.
gt;
gt; quot;JE McGimpseyquot; wrote:
gt;
gt; gt; Yes, unless you're using a named range.
gt; gt;
gt; gt; In article gt;,
gt; gt; Corben gt; wrote:
gt; gt;
gt; gt; gt; Do both workbooks have to be open?
gt; gt;