Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
AutoSum Help Stockwell43 Excel Worksheet Functions 2 May 11th 07 08:14 PM
Autosum Alan[_3_] Excel Discussion (Misc queries) 2 March 19th 07 01:35 PM
autosum Kevin Excel Worksheet Functions 6 November 25th 06 07:51 PM
Macro code to autosum a dynamic length column SlowPoke Excel Discussion (Misc queries) 3 March 31st 06 11:48 PM
create autosum macro along with notation on the side pino Excel Worksheet Functions 0 June 16th 05 09:44 PM


All times are GMT +1. The time now is 04:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"