Hi excel gurus,

I have about 200+ columns in one giant worksheet. I have coded the vba so that each sheet contains a unique pivot table for different columns. That usually leaves me with 20+ sheets which is not very user friendly. My question is that, is there any way to have like a toggle switch between pivot table views? i.e. A drop down menu of some sort, then the pivot table will automatically show up based on predefined rules of columns set within the drop down menu. This way a user can just deal with a drop down menu and be able to view all different pivot tables all in ONE sheet.

Any help is appreciated.