PDA

View Full Version : Pivot table with data validation reference



vinwin06
12-03-2011, 08:37 PM
HI,

I required vba codings for pivot table but the value should be choose from the data validation i have created.

For example : I have two pivot tables in sheet1 and these two pivot table have a common column filed available so i have created the data validation in cell D6. Now i need to give reference to the cell D6 for both the pivot table on the column labels.

Based on the value selected on the drop down the pivot table need to be changed on the both pivot tables.

Regards,

VInwin

shrivallabha
12-03-2011, 10:11 PM
You can post a sample here as to describe your requirement in better manner.

But before that read this:
You have cross-posted this on MrExcel:
http://www.mrexcel.com/forum/showthread.php?t=596418

Please read this advice here:
http://www.excelguru.ca/content.php?184

Be careful next time you do it as it happens unknowingly first time. But people tend to ignore such cross posters if they repeat this behavior.