Finding a value in a range where the value changes cells

[David.Marr.68]

I'm trying to summarize the balance of each of 4 accounts on a single
sheet. Each account is on a separate sheet. The problem is, the
balance changes with each transaction. i.e. on this transaction the
balance is in cell F4, but when I post the next transaction the
balance will be in F5 How can I summarize if the balance keeps moving?

 

[Gord Dibben]

Set up a Dynamic Range

See Debra Dalgleish's site for the how-to bits.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord Dibben MS Excel MVP

 

[David.Marr.68]

Set up a Dynamic Range

See Debra Dalgleish's site for the how-to bits.

http://www.contextures.on.ca/xlNames01.html#Dynamic

Gord Dibben  MS Excel MVP





- Show quoted text -

I'm not an excell guru, but I can see how the dynamic range works, but
how do I apply it? I tried ={range name} and that just poped up an
open file dialog asking for check values.