How hard would it be to...

[CDICKENS]

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

 

[Jack in the UK]

from your question i strongley recomend automation as you ask and keep piviots simple they are stroppy little things best days and make you like easy

stay as you are..

sorry to be negative..