Tricky ComboBox / Filter query
Here's one
On Sheet1, from A1:A2931 I have dates, every day from 01.01.02 to
31.12.2009 (A1="01/01/2002", A2="02/01/2002", etc).
On a Userform I have 2 ComboBoxes: 1 for month, one for year. Is it
possible to use these to filter Sheet1 and leave only those dates
chosen in the dropdowns (eg, December 2004 only)?
TIA
Alan
|