| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automated continuous adding
Hi i have 2 columns. one column outgoings, one column incomings. at the top of the page i also have subtotals for these columns. The problem is that i have to keep changing the cell numbers of th subtotals because new values are added to the columns and therefor make them longer. How do i automate this procedure?? Any help would be greatly appreciated -- highbee ----------------------------------------------------------------------- highbeef's Profile: http://www.excelforum.com/member.php...fo&userid=1616 View this thread: http://www.excelforum.com/showthread.php?threadid=27595 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
automated continuous adding
How about just using extremely large rows?
=subtotal(3,c3:c65536) highbeef wrote: Hi i have 2 columns. one column outgoings, one column incomings. at the top of the page i also have subtotals for these columns. The problem is that i have to keep changing the cell numbers of the subtotals because new values are added to the columns and therefore make them longer. How do i automate this procedure?? Any help would be greatly appreciated. -- highbeef ------------------------------------------------------------------------ highbeef's Profile: http://www.excelforum.com/member.php...o&userid=16167 View this thread: http://www.excelforum.com/showthread...hreadid=275953 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Continuous count down | Excel Discussion (Misc queries) | |||
| continuous typing | Excel Discussion (Misc queries) | |||
| Continuous numbers | Excel Worksheet Functions | |||
| Continuous Refresh | Excel Discussion (Misc queries) | |||
| Continuous Addition | Excel Discussion (Misc queries) | |||
Hybrid Mode
