L
Lorna B
I am building a macro to produce a report that non-computer types will be
able to run based on a customer satisfaction spreadsheet database. I need to
be able to pull information based on dates and think that the best method
would be an autofilter. I want the people to just be able to type in a start
date and an end date and click on the produce report to start the macro. I
need the autofilter within the macro to pick up the date range to use as the
great than or equal to "and" the less than or equal to. I know how to build
the rest of the macro the way that I want it, but don't know how to have the
autofilter reference the cells that the dates will be input into. HELP!!!!
Thanks!!!!
able to run based on a customer satisfaction spreadsheet database. I need to
be able to pull information based on dates and think that the best method
would be an autofilter. I want the people to just be able to type in a start
date and an end date and click on the produce report to start the macro. I
need the autofilter within the macro to pick up the date range to use as the
great than or equal to "and" the less than or equal to. I know how to build
the rest of the macro the way that I want it, but don't know how to have the
autofilter reference the cells that the dates will be input into. HELP!!!!
Thanks!!!!