Mirror My Pivot Table

[Birinder]

Hi,


I have a macro that select each customer from a Pivot table and display their information.




I have another regular table that copy that Pivot table's information to a different tables. I have only linked the pivot table's cell values. so for example column names are


HSA HFA Grandtotal


2 3 5





My issue is if the original Pivot table has less columns my grand total displas vales under the left column in my regular table. Currently it shows:



HSA HFA Grandtotal


2 2




but I want it to display



HSA HFA Grandtotal


2 2



If the customer has both HSA and HFA value then it display correctly in both tables


HSA HFA Grandtotal


2 3 5


Does anybody knows any fix to this?


Thanks,


Birinder

 

[Birinder]

Not sure why but my question does display my tables correctly, please review the attachments to look at the tables