Subtotalling an unknown number of rows

djurmann

Board Regular
Joined
Jan 13, 2006
Messages
246
Hi folks,

I have a stockesheet set up with subtotals, conditional formats all very nice. However if I want to Insert-row to add another order The subtotal is not updated...any ideas? I've looked on the web but no joy :(

Many thanks,

Danny
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

sgremmo

Board Regular
Joined
Sep 1, 2004
Messages
55
It possible that my english isn't so good, but if I understand, you can recorder a macro in which:
1 remove subtotals
2 sort column if necessary
3 apply subtotals
you not need write a line of vba code.

It's correct?

Ciao

Simone
 

djurmann

Board Regular
Joined
Jan 13, 2006
Messages
246
Thanks sgremmo

Thanks sgremmo,

Sorry it has taken me so long to reply (your English is excellent by the way). Just to let you know that I have found another way without using subtotals.

Best wishes,

Danny
 

seenfresh

Well-known Member
Joined
Jul 12, 2006
Messages
1,141
djurmann,

I am curious as to which other way you use to subtotal your data, as I have the same problem and also I hate manually typing in the subtotal function everytime I need to use it/ or go to the function commands

Thanks

Sean
 

Forum statistics

Threads
1,137,332
Messages
5,680,875
Members
419,937
Latest member
Talic

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top