I can't figure out subtotaling my spreadsheet...can someone please help me understand?

[rharri1972]

Hello All!
I have a spreadsheet which is an MRP (Materials Report Planning) report. I work for a fabrication company and this report gives me the metal material needed based upon orders placed in the system.

I have two worksheets
Control button is on Worksheets("INSTRUCTIONS") and the actual report is on...wait for it....... worksheets("REPORT") ha!

I have columns A:M with each header being in ROW3 and data starting in ROW4. These rows go down to about 1500 to 1600 so if needed I would use a range of rows of about 2000 as sometimes depending on jobs in system, it could reach that number.

I would first need to sort entire range A-Z using PRODUCT ID in COLUMN E.

I would then like to SUM at each change in PRODUCT ID and add Total to MRP QTY which is COLUMN H.

If anyone can help it is GREATLY appreciated. If you are also willing... can you break it up with explanation as everything I have looked at trying to figure this out makes me feel like I need a computer science degree to figure this out. Obviously the extra work to explain is not needed but would be very much appreciated just so i can have an understanding.

 

[GraH]

Hi,
On he data ribbon there is the sort button you can click.

Also on the data ribbon, in the Outline Section you find Subtotal.

Results in.

 

[rharri1972]

Hi,
On he data ribbon there is the sort button you can click.
View attachment 51151

Also on the data ribbon, in the Outline Section you find Subtotal.
View attachment 51152

Results in.
View attachment 51153

GraH... thank you so much for your time and effort., My apologies as the one very important information i left out of this is that I want to be able to do this with vba if that is possible.

 

[GraH]

I see, always good to be very explicit on those requirements.
Did you try to record these actions?

 

[rharri1972]

I see, always good to be very explicit on those requirements.
Did you try to record these actions?

I did not...I will try that and then see if it works...if not...i will come back to give results. Thank you so much!!