Split the results of a search in to 2 list boxes

Hi everyone. I am trying to split the results of a search into two separate listboxes. The user would enter the date in the textbox above "Click here to see class for selected date". They would then click on the command button. I need the results from that date search to be divided into the appropriate list bos. The ones that have a Y or Yes in the "Clear" column on the worksheet to go into the listbox marked "Clear". The ones that have a N or NO in the "Clear" column to go into the listbox marked "Not Clear". Thank you for your help