A:Quote:
Originally Posted by mdmackillop
My initial question was based on the 'actual' data I am working on. The sample I provided is 'dummy data', the design is the same as the actual. Just the number of rows are different.
Wrong position:
"I still don't know where the wrong positions are." Are you asking where the wrong positions are...when I used the macro or the subtotal function?
I'll answer both:
I used the code that was given to me from previous posts. That code didn't work, rows are added at the wrong places.
Subtotals: I tried to use the subtotal function. Data -> subtotal. [At each change in] I pick the level I want (products or product column). Then I pick the sum function. [Add subtotals to] I pick the columns I want to add the subtotals to, which are the year columns.
When I did all that, instead of showing the subtotals of all the products, it basically inserted subtotals for every product.
If you still cannot get a clear picture, I am trying to sum up or subtotal all the products under every business for the years 2010, 2011 - if i recall correctly those are the year columns on the sample provided. So, basically, I want an aggregated or sum number under column 2010 and 2011 for all the products under each businesses.
Thanks.
