Modify code to change Sum Range

Thanks - workbook attached

Active cell is F56 (pink) for testing purposes
I'm working my way (the hard way) to getting a subtotal of each group on to the office subotal line. I've copied the subtotal values over to columns Q-W, I'm using Start/End in column P to give me the range to total


Response from Richard doesn't work as it hard codes Q11 rather than finding the top cell in column P

Thank you for any assistance!

Hi, Richard,

I have a Start cell and an End cell labeled in column P
My active cell is F56
I want to go over 10 to P and xlup to "start" to get the row #s to sum, but sum them from Q
The code below correctly gets the range in column P, but sums column P when I'd like to sum Q
Your code is summing Q65-Q101, so it's going down from 56 even though it uses xlUp, which I don't understand.
P is not contiguous
You can look at my workbook to see what I'm trying to accomplish. Once I get this formula working, it will be put in a loop to work on all Office subtotal lines (I hope)

Please Login or Register  to view this content.

Thanks for any help!

Marcol,

OMG! Thank you! That is so very helpful!!

I would love your opinion - is copying the group numbers out and using your formula the best way to get the group subtotals onto the office subtotal line?

Thank you so much

Karin

Can't look at it just now. I'll check when I get back.

(Remember the time difference, it's evening here.)

Have a wonderful evening! Hope to connect again tomorrow sometime.

Hi, Marcol,

Thank you - this is on the right track. I want to put the start/end in through VBA

I appreciate your assistance very much!

Hi dallasallenz

Why have you quoted my first Post?

If you can see something I have missed, you can get the latest sample from Post #11

Any help is greatfully received on this Forum.

Hi, Marcol,
I just want you to know that I am here and able to work on this now (finally past the Thanksgiving holiday and all the cleaning, cooking, relatives and time that it entailed - very thankful for you and everyone here who helps me!)
I'm going to work it all through and attach a workbook, but it will take me a while.
Thank you!!!!

No problem,

Just as a point warning, beware the revenge of the turkey..

From 20 turkey eggs in 1950 to 7m birds annually in 2010, Bernard Matthews became the largest turkey farmer in Europe

He died at thanksgiving this weekend, mind you he was 80......

Hi, Marcol,

Here it is, everything is working very well. It may not be the absolute best way to do things, but it is getting is done.

I just need to figure out how to make the Grand totals a sum instead of hard coded so that it will total up the manual entry/calculated numbers in columns J and L. (user can put in a percent in column I or change column J to an amount)

Thank you so much!!!