VBA to select a date range of data return from a table

[Tiengoku]

Hi guys,

I am really new to VBA so I am looking for a way to create a VBA code so that it can return results on a pivottable for me, within a certain date range, which will be determined by two cells.

i.e A5 = start date A6= End date

And these two would be used as references for the pivot table to know which range to get the data from. i cannot attach the actual copy. I have tried a few different codes and nothing seems to work .

Thanks!