Adjust VBA to Only Copy Values to New Sheet

[clto0501]

Hi everyone,
I'm wondering if someone can help me adjust the code is this other thread http://www.excelforum.com/excel-prog...in-cell-f.html so that it only transfers the values instead of any formulas in sheet 1.

[AB33]

Please Login or Register  to view this content.

[clto0501]

Works great! Thank you so much!

[clto0501]

Thank you for your help. The code worked, but I am wondering if there is a way to change it a bit. I noticed that if I start typing into the wrong row of column six and delete it, the row still gets moved to sheet 2 when I leave the cell. I tried to change Target.Cells.Count=1 to Target.Value>0 (since I am entering a date into the cell). The macro works when I did that, but I get run-time error '13' at the end of it. Is there an easy way to fix this that I am missing?