Hi,
When reporting for whole of Europe I create a pivot table with country as a filter. To give each country manager their own data I currently show pages based on country, then have to save each worksheet as a seperate workbook. I then have to edit the filter linking back to access so that the country manager can only see the data for their own country. I do not want to only use hide on the pivot table, as I do not trust then not to get around this.
Is there an easy way to code all these steps ?
Can any one help as I am up to making 20 different workbooks for each European query.