Moved data to new sheet based on list selection

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

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>