Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to filter data based on selected data
Hi, I am looking for a macro that requests input of a reference code and then
a date and then filters the data in my spreadsheet based on this criteria. I am using excel 2007. Any help with this will be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to filter data based on selected data
You can probably record a macro while doing it manually and then clean it up
and add input boxes to ask the question or input your variable in a cell and use that. If all else fails, If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "pkk1964" wrote in message ... Hi, I am looking for a macro that requests input of a reference code and then a date and then filters the data in my spreadsheet based on this criteria. I am using excel 2007. Any help with this will be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Filter on Selected rows and columns | Excel Discussion (Misc queries) | |||
Filter Data based on cell value | Excel Discussion (Misc queries) | |||
Filter Data based on criteria | Excel Programming | |||
Auto input data on one sheet based on row selected in another shee | New Users to Excel | |||
How to filter and list data based on different data. | Excel Worksheet Functions |