Macro to select Date field in Pivot table

[ccofmars]

Hi I am using Excel 2010. My level of VBA is below novice and I need some help creating a macro that will prompt a message box asking to type of date and that consequently only select the date in the pivot table.

It is an attendance report that I am building.
I have already created a button that prompts a macro to refresh the pivot.
Now I already created a button but I need a macro that will prompt the user to type of date, and the pivot will only show the employees that are present on that date.

please help!ray:ray:

I thank you in advance.
Chantal

 

[ncalenti]

Do you know how pivot filters work? Try dragging the date field into the filters box on the pivot table editor. If you really want this functionality done with a button and macro, I can help you do that. I just want to make sure you know that it could already be built in.

 

[ccofmars]

Ncalenti

thank you for your reply. Yes I know how to use and manipulate pivot tables, however my employees do not. So I am trying to make it as easy and user friendly as possible, which is why I want to use a macro (by pressing a button on the worksheet).

your help is greatly appreciated.

Chantal