| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatically apply formula to new row
I have a spreadsheet that requires the constant addition of new rows
of data and I need the sheet to automatically recalculate the desired totals to include the new row. I am fairly new to macros and was seeking some basic direction on how to program this. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
automatically apply formula to new row
Insert before the last row in your formula or create a defined name or =SUM(A2:OFFSET(A2,MATCH(9999999,A:A),0)) -- Don Guillett SalesAid Software "CrazySwayze" wrote in message ups.com... I have a spreadsheet that requires the constant addition of new rows of data and I need the sheet to automatically recalculate the desired totals to include the new row. I am fairly new to macros and was seeking some basic direction on how to program this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any way to apply a filter automatically after changing a cell? | Excel Discussion (Misc queries) | |||
| how do I tell Excel to apply cell styles automatically | Excel Discussion (Misc queries) | |||
| Can I apply automatically the same filter on many pivot table ? | Excel Programming | |||
| automatically apply a macro to all worksheets | Excel Discussion (Misc queries) | |||
| Automatically apply a fill when entering text | Excel Discussion (Misc queries) | |||
Linear Mode
