Re: Subtotal Data in Number of Columns
Thanks for helping me out - I didn't see how the two fit together.
I ran the macro and I'm trying to make a couple adjustments. One - in the original file, column A had the heading "Category 1" and data below it, which is being used to group the subtotals. When I run the macro, it shifts my data one column to the right. Is there a way to keep the detail for "Category 1" in column A with the total (such as "A Total")?
Also, the subtotals end in the correct column (the 3rd-to-last column) but the columns with headings "Category 1" and "Category 2" should not have subtotals. Is there any way to assure that the subtotals don't begin until the 3rd column?
I've tried playing around with the macro, but I can't figure out how to make these changes. Thanks in advance for your help!