I've been working on this problem and am stumped. When I click on an item in the userform combobox all the data is transferred to the next empty row instead of the existing item row on the worksheet and I end up with duplicates. What I would like to accomplish is if the item already exists in the combobox then add the userform data to the existing row, otherwise if the item does not exist I would like the item and data to be transferred to the next empty row.