Hi everyone.
Please see attached.
Basically, I would like to be able to run a macro wherein an input box appears and asks the user to enter a date range, and then a pivot is created that is filtered by that date range.
The Data sheet is the source data, and the Result sheet is the result. In this case, the user's date range is between 2/6/2014 and 3/20/2014 .
I am just totally stuck and would really appreciate any help on this.
Bookmarks