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