Auto propagate formulae?
 

I need a sheet to track money received. It should total weekly and Y.T.D. I won't
know in advance how many transactions will occur in a given week. Can Excel recognize
the number of rows and propagate the formulae automagically as transactions are added?

Where can I find templates for Excel 2000?
Thanks,
Mike

DATE CLIENT Amount Paid Wk Total Y.T.D
2008
SEPTEMBER
9/16/08 Client, Connie $125.00 $125.00 $125.00
9/16/08 O’Client, Bob $150.00 $275.00 $275.00
OCTOBER


NOVEMBER


DECEMBER


2009
JANUARY

Auto propagate formulae?
 

Hi Mike,

If I understand your question the answer would be no in 2000 without using
VBA. But both 2003's List feature and 2007's Table feature provide this
functionality.

Cheers,
Shane

"MikeR" wrote in message
...
I need a sheet to track money received. It should total weekly and Y.T.D.
I won't know in advance how many transactions will occur in a given week.
Can Excel recognize the number of rows and propagate the formulae
automagically as transactions are added?

Where can I find templates for Excel 2000?
Thanks,
Mike

DATE CLIENT Amount Paid Wk Total Y.T.D
2008 SEPTEMBER 9/16/08 Client, Connie $125.00 $125.00 $125.00
9/16/08 O’Client, Bob $150.00 $275.00 $275.00
OCTOBER

NOVEMBER

DECEMBER

2009 JANUARY

Auto propagate formulae?
 

Shane Devenshire wrote:
Hi Mike,

If I understand your question the answer would be no in 2000 without
using VBA. But both 2003's List feature and 2007's Table feature
provide this functionality.

Cheers,
Shane

Thanks, Shane -

VBA would be OK. I've just started to play with it.