Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to AddRow and Autosum
I'm looking for a macro that will add a row if column A is blank and to auto
sum columns N thru T. This would be most helpful. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to AddRow and Autosum
I am not too sure exactly what you want. Are you trying to add subtotals each
time a blank cell is found in column A or just what? Can you post some kind of example? -- HTH... Jim Thomlinson "simplymidori" wrote: I'm looking for a macro that will add a row if column A is blank and to auto sum columns N thru T. This would be most helpful. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to AddRow and Autosum
A B C D E F.... N O P Q R S T
a a a Subtotal b b b b Subtotal Yes to your question. Thanks! "Jim Thomlinson" wrote: I am not too sure exactly what you want. Are you trying to add subtotals each time a blank cell is found in column A or just what? Can you post some kind of example? -- HTH... Jim Thomlinson "simplymidori" wrote: I'm looking for a macro that will add a row if column A is blank and to auto sum columns N thru T. This would be most helpful. Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to AddRow and Autosum
have you looked into using Data - Subtotal from the XL menu. You would need
to remove your blank lines before you start, but it does exactly what you are asking without any code... -- HTH... Jim Thomlinson "simplymidori" wrote: A B C D E F.... N O P Q R S T a a a Subtotal b b b b Subtotal Yes to your question. Thanks! "Jim Thomlinson" wrote: I am not too sure exactly what you want. Are you trying to add subtotals each time a blank cell is found in column A or just what? Can you post some kind of example? -- HTH... Jim Thomlinson "simplymidori" wrote: I'm looking for a macro that will add a row if column A is blank and to auto sum columns N thru T. This would be most helpful. Thank you. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to AddRow and Autosum
Hi Jim,
I have about 200 different sections under 1 tab which needs subtotaling from N-T. So the subtotal from the menu bar will not suffice for this task. Inserting that extra row if and adding the subtotal fields will help. Thanks for your suggestion. "Jim Thomlinson" wrote: have you looked into using Data - Subtotal from the XL menu. You would need to remove your blank lines before you start, but it does exactly what you are asking without any code... -- HTH... Jim Thomlinson "simplymidori" wrote: A B C D E F.... N O P Q R S T a a a Subtotal b b b b Subtotal Yes to your question. Thanks! "Jim Thomlinson" wrote: I am not too sure exactly what you want. Are you trying to add subtotals each time a blank cell is found in column A or just what? Can you post some kind of example? -- HTH... Jim Thomlinson "simplymidori" wrote: I'm looking for a macro that will add a row if column A is blank and to auto sum columns N thru T. This would be most helpful. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoSum Help | Excel Worksheet Functions | |||
Autosum | Excel Discussion (Misc queries) | |||
autosum | Excel Worksheet Functions | |||
Macro code to autosum a dynamic length column | Excel Discussion (Misc queries) | |||
create autosum macro along with notation on the side | Excel Worksheet Functions |