Stu Dapples
Active Member
- Joined
- Jan 12, 2009
- Messages
- 252
I have a large spreadsheet which collects data from a database for analysis. There are around 13000 records and growing. I use pivot tables to display info from selected weeks, months etc and output graphs to show output, quality etc etc.
My issue is that I want to hand the spreadsheet over to our production guys (who are basic excel users) without giving them access to pivot tables etc which they invariably screw up. I would ideally like to set up a select drop down with week numbers in that would then drive the filter on several pivot tables to return data for the required week number...
Any ideas? I tried entering the function in the table and it says you cannot use a function, anyone got a clever workaround?
My issue is that I want to hand the spreadsheet over to our production guys (who are basic excel users) without giving them access to pivot tables etc which they invariably screw up. I would ideally like to set up a select drop down with week numbers in that would then drive the filter on several pivot tables to return data for the required week number...
Any ideas? I tried entering the function in the table and it says you cannot use a function, anyone got a clever workaround?