View Single Post
  #1   Report Post  
 
Posts: n/a
Default 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