ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   multiple pivots updated with selection in one table (https://www.excelbanter.com/excel-worksheet-functions/30906-multiple-pivots-updated-selection-one-table.html)

BorisS

multiple pivots updated with selection in one table
 
I have multiple pivots (all taking data link from the first pivot table) on
one sheet. Each sheet will have a "Salesperson" page field. I'd like to be
able to drop down the first table and select the salesperson and have all the
other tables automatically do the same.

Anyone?

--
Boris

Ron Coderre

Check out this tutorial link.....
http://datapigtechnologies.com/flashfiles/pivot10.html

Does that help?
--
Regards,
Ron


BorisS

perfect. thanks so much.
--
Boris


"Ron Coderre" wrote:

Check out this tutorial link.....
http://datapigtechnologies.com/flashfiles/pivot10.html

Does that help?
--
Regards,
Ron



All times are GMT +1. The time now is 01:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com