Macro/If Then statement to move a row of data

I am using 2010 Excel and here is what I am trying to achieve. I have a spreadsheet with drop down menu's. One of the columns I have is APPROVED. The drop down menu is YES and NO. When the user marks the field YES, I would like the row to cut and paste into a different worksheet (To track approved rows).

1. If there is an "YES" in column L, then move entire row to the first available row on sheet 3.

2. Delete empty row in Sheet 1

I would like the statement/macro to apply to the entire sheet.

Can anyone lend me a hand?

Maybe:

Please Login or Register  to view this content.

That didn't seem to work. I am really new to macro's, is there a step to activate it that I need to do? Thanks for all the help.

This is the row where there is an error occurring.

Rows(i).Copy Sheets("Sheet3").Range("A" & Rows.Count).End(3)(2)

Can you attach a sample file with some dummy data.