Drop down selection copies data onto separate sheet

[Linky01]

Hi, I'm not entirely sure how to explain this but.....

I have a workbook with 2 different sheets on it. On the first sheet there is a drop down menu in column E with the options 'Ordered' 'Not Ordered' and 'Hold'.

What I want excel to do is when the option 'Ordered' is chosen in the drop-down in Column E, to copy the data from column A of that row, and copy it onto the second sheet, therefore creating a sheet with all those that have ordered...

Can someone help?

Thanks in advanced.

 

[BobUmlas]

Attach this code to the sheet1's code module:

Private Sub Worksheet_Change(ByVal Target As Range)
If LCase(Target.Value) = "ordered" And Target.Column = 5 Then
Target.Offset(, -4).Copy Sheets(2).Cells(Rows.Count, 1).End(xlUp).Offset(1)
End If
End Sub

 

[Linky01]

Thanks for that. Just one thing...

I have never used Macros in my life! So woul you be able to give me the steps I need to do to insert this code?

MT

 

[BobUmlas]

Right-click the sheet tab, select View Code, then paste in the answer.

 

[Linky01]

Thanks, but it doesn't seem to be working!

 

[BobUmlas]

feel free to send me a copy of the file -- bobumlas (at) hotmail (dot) com