Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to AddRow if Blank and Autosum
Anyone have any ideas?? Thanks
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 | |||
Macro to AddRow and Autosum | Excel Discussion (Misc queries) | |||
Macro not recognizing blank lines as blank | Excel Discussion (Misc queries) | |||
Macro code to autosum a dynamic length column | Excel Discussion (Misc queries) | |||
Macro To Insert Blank Row? | Excel Discussion (Misc queries) | |||
create autosum macro along with notation on the side | Excel Worksheet Functions |