Auto propagate formulae?

  • Thread starter Thread starter MikeR
  • Start date Start date
M

MikeR

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
 
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
 
Shane said:
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
Click to expand...

Thanks, Shane -

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