I want to create a dynamic Pivot Table based on a search criteria from a Userform. The criteria will be a date search (from and to dates – 2 separate text boxes). When submitting the Userform, all records in the user-selected range will then be displayed in the Pivot Table, for example show all records between dates 1/3/11 and 31/3/11.

All the source will be coming from the same Excel Worksheet (no external data).

Will this require mounds and mounds of VBA coding, or is there a simpler solution.

Note: I’m at the Novice stage of VBA/SQL?

(In anticipation) Many thanks