| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a macro to run autofilter based on contents of 2 cells
I have a list of dates in column A, starting in cell A3 upto cell A1002. I
have the autofilter in place for column A. I want to run a macro that will filter these dates to show only the ones that are equal or greater than the first date that is in cell A1, and also that are equal or less than the second date in cell B1. I can filter the information using the custom part of the autofilter, but I'd rather be able to type the to and from dates in the two cells stated and press a button to run the macro. I hope that makes sense. Any help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To Create a Value Based Upon The Contents of A List | Excel Worksheet Functions | |||
| Create filename based on cell contents | Excel Worksheet Functions | |||
| how do i create a macro that would check the contents of cells | Excel Discussion (Misc queries) | |||
| how do i create a macro that would check the contents of cells | Excel Discussion (Misc queries) | |||
| Create filename based on cell contents | Excel Programming | |||
Threaded Mode
