prompting user for selecting values in the pivot page filter using vba code

[soniajaswal]

Hello All,

I need some help with coding the user prompts within VBA excel.

I have a sheet of raw data that i want to process/filter in pivot table and thereafter copy and paste the filtered data from Pivot table to a new sheet. I have put this perfectly in the vba code. I want to make an additional change to this. My raw data also has 'Date' field. I will be required to filter the data using selective dates. Do i have an option in Vba to prompt the user for the selection of dates for filtration first and then copy paste the filtered data to the new sheet.

Please help me with this.

THanks soo much!

Sonia

[mahaveersomani]

can you provide a sample file with your vba code ?

[soniajaswal]

sample.xlsm

Hi, i have attached a sample file for your reference with the code in it.

Thanks,
Sonia