View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kalyan Kalyan is offline
external usenet poster
 
Posts: 11
Default DYNAMICALLY data source for pivot table

is there any way to change datasource dynamically

Example.

I will three Command Button, each button refer to three data source

Button A - Production
Button B - Development
Button C - QA

based on click, pivot table will change the data source, if i press refresh
i will populate corresponding data

thanks