I have this code that adds up amounts according to a data report sheet (Concur Data). I will provide my automation and excel below. If you run my automation with the right path it makes 3 more sheets that try to duplicate the pivot tables I provided in the same excel worksheet. How would I find the subtotals as shown under “Total” in bold?
Main - Copy.xaml (37.8 KB)
COPY 2021 YTD Weekly Billing Expense Allocation.xlsx (63.7 KB)
Example of the subtotals under “Total” (Also in excel worksheet)