Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am building a macro so that people in my organization can produce reports
based on a customer satisfaction spreadsheet database. I need to be able to pull data from the customer responses based on date ranges and I am thinking that the autofilter is the best choice for this. I want people to be able to input a from date for the greater than = to choice in autofilter and input and end date for the less than = to choice. I would then like to have them click on a radio button to initiate the macro and have the macro run the routine to pull the information to a query spreadsheet from the satisfaction spreadsheet based on the dates given. Piece of cake I am sure for you MVP types, but I am stumped on how to have the autofilter pull the dates for the query from the input cells. :( Your help would be hugely appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I use a macro to autofilter in excel | Excel Worksheet Functions | |||
autofilter macro | Excel Discussion (Misc queries) | |||
macro for 4 constraints in autofilter | Excel Discussion (Misc queries) | |||
Keep autofilter after macro is run | Excel Worksheet Functions | |||
Autofilter Macro Help | Excel Discussion (Misc queries) |