I think there may be one problem; my dropdown isn't in a particular cell, but in a range (IE all of column F). So, I'll be typing in the cells on row 10. The last cell I fill will be the dropdown. When I choose that dropdown, I want the row containing that choice to be copied to another sheet which is named (already) with that dropdown choice.