Try browse this recent thread (similar query)
with responses for 2 approaches:
http://tinyurl.com/ddo6m
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"scronk" wrote in
message ...

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