Filter Excel Pivot, based on user entry form

[Jayco]

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!

 

[MarkM]

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