Niranjanrajrishi
Member
Hi,
Would like to seek support to complete my VBA code to create my report. I have completed the data formatting and pivot table creation. Now I need to sort the Pivot table with values and create group for positive amounts (the data has both positive and negative values). Once the group is created, the same data (only positive values) needs to created as worksheet to prepare further reports. The positive amounts (can call it as receipts) needs to reported out with multiple tables.
I am stuck up with the Group option and then create sheet with the positive values. I have attached my macro with data (till pivot). Can anyone help?
Would like to seek support to complete my VBA code to create my report. I have completed the data formatting and pivot table creation. Now I need to sort the Pivot table with values and create group for positive amounts (the data has both positive and negative values). Once the group is created, the same data (only positive values) needs to created as worksheet to prepare further reports. The positive amounts (can call it as receipts) needs to reported out with multiple tables.
I am stuck up with the Group option and then create sheet with the positive values. I have attached my macro with data (till pivot). Can anyone help?