Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
Limited byrows propagate a value via macro to all cells in column | Excel Worksheet Functions | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Can I propagate a date from one worksheet to another | Excel Worksheet Functions | |||
Propagate Array Formula Down Column | Excel Discussion (Misc queries) |