CDICKENS
Active Member
- Joined
- Mar 24, 2002
- Messages
- 498
I have a few workbooks that I use pivot tables to "compile" different reports using essentially the same sales data. Would it be somewhat easy to create a Form page with a drop down box listing the reports that can be generated, and a box to specify a range of dates to be included in the report.
I guess I am actually asking if you can record a macro that "compiles" a report, based on a user defined date range. I have not used any macros in a while so before I attempt this I was interested to know if it can even be done.
Thanks for any input,
Chuck
I guess I am actually asking if you can record a macro that "compiles" a report, based on a user defined date range. I have not used any macros in a while so before I attempt this I was interested to know if it can even be done.
Thanks for any input,
Chuck