Formating (pivot)

[sarat]

Hi all,

I want to format data in dynamic range in attached sheet. For the column (CT and SR/LIT), always sub-columns are changing frequently (at maximum 4) that means for columns CT, maximum 4 columns are added or subtracted (same for Lit/SR).

Advance thanks

[Bob Phillips]

Just format the pivot table, Excel will take care of shrink/expand.