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!
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!