Hi, I have tried searching for VBA code to add subtotals below each change in Company code and currency ( For example in company 30 we have GBP and PLN) so that would need to be split out.
I have the data in a pivot table and I am copying the data onto a separate spreadsheet (INTL_PIV_1) then trying to format it as below. Unfortunately, ADP must have the data in this format to upload and will not take it in the pivot table format.
Can you help with the code to add subtotals by CO ( company code) and Currency? And add bold and underline the subtotal? The range of data will change each time. The data will start in Column A to column F ( not in K like below) Oh and it looks like they add a row between each subset.
The basic data will be without the subtotals on sheet INTL_PIV_1
The macros I found would only subtotal by company and not also currency.
any help is appreciated.
Sharon
I have the data in a pivot table and I am copying the data onto a separate spreadsheet (INTL_PIV_1) then trying to format it as below. Unfortunately, ADP must have the data in this format to upload and will not take it in the pivot table format.
Can you help with the code to add subtotals by CO ( company code) and Currency? And add bold and underline the subtotal? The range of data will change each time. The data will start in Column A to column F ( not in K like below) Oh and it looks like they add a row between each subset.
The basic data will be without the subtotals on sheet INTL_PIV_1
The macros I found would only subtotal by company and not also currency.
any help is appreciated.
Sharon