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


--
scronk
------------------------------------------------------------------------
scronk's Profile: http://www.excelforum.com/member.php...o&userid=28175
View this thread: http://www.excelforum.com/showthread...hreadid=477027