Positioning Subtotals to the next column on right

[1cyril1]

Hi, I've searched through 4 pages of "Subtotal" posts in this forum but didn't see one that covers what I need. I just want to have Subtotal values appear to the right of the column being sub-totalled rather than directly below each group of numbers. The col to the right would be created just to hold the subtotal values and facilitate filtering on the subtotal lines only. Is this easy to do?

(I've seen somewhat convoluted suggestions elsewhere that involve showing visible cells but I gave up - hoping there's a simpler approach!)

All suggestions most welcome - thanks!

Cyril

 

[Peter_SSs]

You're welcome.

 

[1cyril1]

Gentlemen - I've just tried all 3 suggestions and they all work excellently To say I'm happy would be an understatement. May your philanthropic endeavours bring you both fulfilment and lots of good karma!

Take care - Cyril

 

[Peter_SSs]

Thanks for the follow-up.