Hi
I need to program a macro that uses subtotals.
The problem is that i need the subtotals to sort by multiple columns. I have a macro that reads data and writes the data in the sheet but i cant find a way to make subtotal rows that consider multiple rows. I can only find a way to create subtotal rows based on either row A or row B (in the example picture: either by Animal change or by color change, but i need it to create the rows by all columns). And also the subtotal (Data-Subtotal) app is adding all the subtotals to different rows but i need them to be on the same row.
So i was wondering if there is a way to do it since i havent been able to find any help by googling?
I dont have permissions to post the original data but i added an illustration to what am trying to achieve
Bookmarks