Bagharmin
Board Regular
- Joined
- Nov 22, 2010
- Messages
- 168
Currently, my code takes data from the master table, creates a secondary table on another sheet, then refreshes the source data range of the Pivot Table and Pivot Chart that are on a 3rd sheet. I've done this since, based on the way the data in the master table is structured (and changing the layout isn't an option), I can't create a Pivot Table and Chart that show the data the way I need. My question is, instead of my code spitting out the raw data onto a second sheet so I can create the table I want, can I dump the data into an array and have VBA create the Pivot Table and Chart (instead of just refreshing it) using that array as the source data? If I did that, would I run into problems if someone wanted to change the look of the Pivot Table/Chart?
Just looking for general input and guidance. Thanks so much.
Just looking for general input and guidance. Thanks so much.