How hard would it be to...

CDICKENS · Apr 30th, 2002, 02:13 PM

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 · Apr 30th, 2002, 03:20 PM

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

Apr 30th, 2002, 03:20 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	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.. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 02:13 PM	#1
CDICKENS Board Regular Join Date: Mar 2002 Posts: 444	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