Quote Originally Posted by xld
What you would do here Ted is, first do a find for 100 mtrs. If found, then do a further find for the second criteria, under 21's saya, BUT, make sure that the row if found is not greater than the last row in the 100 mtrs section, in case you find under 21's in the next section (of course this data management code is superfluous if you know exactly waht the data will look like, and manage that within the code).
As in..
Set Tgt = ActiveSheet.Column(1).Find(What:=Me.Combobox1.Text, Lookat:= xlWhole)
Set Tgt = ActiveSheet.Column(2).Find(What:=Me.Combobox2.Text,Lookat:=xlWhole)

providing the Combobox 2 contained the different age groups?

Ted