Filter Excel Pivot, based on user entry form
I'm attempting to create a single Pivot Table that automatically
applies a filter, depending on what the user enters into a form. For example, salesperson "John" opens the excel file and enters his name into a pop-up form. Then a Pivot is displayed with only John's sales--filtered by selecting John's salesperson number in the Pivot's filter. Does anyone know how to do this?? Help would be greatly appreciated! |
Filter Excel Pivot, based on user entry form
I have been working on something similar to this using combo boxes. This
should work. You can create a macro to accomplish this using the following code: ActiveSheet.PivotTables("PivotTable1").PivotFields ("salesperson name").CurrentPage = ActiveSheet.Range("G3").Value When a user types a salesperson name into cell G3, or which ever you specify, they can run the macro to update the pivot table. You can create a button for them to click and assign the macro to that to make it easier on the users. Hope this helps "Jayco" wrote: I'm attempting to create a single Pivot Table that automatically applies a filter, depending on what the user enters into a form. For example, salesperson "John" opens the excel file and enters his name into a pop-up form. Then a Pivot is displayed with only John's sales--filtered by selecting John's salesperson number in the Pivot's filter. Does anyone know how to do this?? Help would be greatly appreciated! |
All times are GMT +1. The time now is 10:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com