I am trying to use a combox to select an a Equipment Location (which is stored in row 2 on my sheet). If the location is found I would like to add all the Equipment ID's with that location (which is stored in row 1 on my sheet) to a second combobox. Then I would like to be able to select one of the Equipment IDs from the second combobox and click a command button that will delete the column. I have been able to search for one instance and add it to the combobox but haven't been able to figure out how to search for all instances and get them to appear in the second combobox. Any help would be appreciated. Thank you.