PivotTable

[Tyler_Durden]

This is really my first attempt at a pivot table to please excuse my ignorance…

I have a macro that will pull in a few different spreadsheets to create the Holdings sheet on the example, this is just a small sampling. The macro essentially just gets everything going to make this piviot table, I have no problems with the macro.

I have used the wizard to get the information loaded in for a pivot table and it works fine. However I’m wondering if I can somehow add a static field to the right of the pivot table that will reference the account and account mv on the Holdings page? That way when the Ticker is changed, the number of columns in the pivot table change as well, I would like the account mv to also adjust its place so it doesn’t get overridden by the column adjustment. Is this possible? Also, is it possible to dress up the data a little bit in the pivot table? I appreciate your help!