VBA - Excel Breaking Out Total Column into 3 Categories, all on same line

[ckp90c]

Hello,

I have a sheet called "2017 OTP Comparison" which houses tax data.

There are the following columns

A. Tax Type - Tax Return, Provision, or RTP designation
B. Adjustment - Several different kinds
C. Total - The numeric total for each adjustment
D. Entity - Several different kinds
E. Year - All 2017
F. Temps/Perms - Either Perm or Temp designation
G. Pre/Post Tax - Either Pre-Tax or Tax Affected designation

My goal is to create 3 'Total' fields instead of just one total, these would be 'Tax Return Total', 'Provision Total', and 'RTP Total'.

However, I want these to be grouped onto one line for each Entity/Adjustment combination, so you would see the Tax Return, Provision, and RTP totals on the same row.

Is there some VBA code I can add to my existing Macro to make this feasible?

I can provide a dummied out Excel attachment if needed.

Thank you so much!!!

 

[TDCox]

Hi @ckp90c

Are you talking about having one row at the end that totals all the tax amounts by type, or on each line, or by section? Assuming either the first or third (or first and third), you could simply total on every line and then total at the bottom; if there are sections it is still possible but becomes more complicated depending on how the sections are broken up.

What does your existing Macro do?