I am trying to move an entire row to a new sheet in the same workbook once a specific list item is selected.

Example: Cell in row on sheet 1 has 4 items to select in a pull down menu list, once number 4 is selected, I want the whole row moved to the next available row in sheet 2.

Any ideas?

Scott