Hi James, thank you for this video. Really helpful, my use case however needs one more step which is taking these subtotals to a new sheet and copy just one value from the sheet as the report is strictly for the totals with one row each for product, color etc. Could you assist with that?
At last a real life working solution..thanks
Thank you for you kind words
Ctrl + A to highlight all data
thank you thank you this helped me
Hi James, thank you for this video. Really helpful, my use case however needs one more step which is taking these subtotals to a new sheet and copy just one value from the sheet as the report is strictly for the totals with one row each for product, color etc. Could you assist with that?