Pivot tables - All Change with Validation List




I have an Excel workbook with several sheets in it. I have the following


Basically, I need the summary sheet to show me values from each sheet, which
is actually the Grand Total of each pivot table (one per sheet).. I have
done this no problem, however, I want to have this table on the summary sheet
as interactive, so if you choose UK from a validation list on the summary
sheet, I want all the pivot tables to update to filter on UK (which is the
Page filter) and therefore the grand totals showing on the summary page would
be for UK data, then if I pick France, all pivot tables would change to be
French data..

Can anyone help me?

Thanks and Happy Holidays,

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question