Cut/Delete row and paste to different sheet based on cell value in column

**williamthomp** · 12-28-2012, 12:23 PM

OK..I think this is pretty straight forward but so many answers out there it has me confused
What I am trying to do is this...based on a value ( Letter "þ" )in one sheet in column G I need have the row cut and pasted to a new sheet ( "Complete" ) The cut rows need to be added to the next available row at the end of the ( Complete) sheet. The other thing that needs to happen is I can't have blank rows on the first sheet so when the row is cut it also needs to delete the blank row or not leave a blank row on the first sheet.

Any help would be greatly apprciated.

thanks

**AB33** · 12-28-2012, 12:40 PM

Put this code in sheet 1

Please Login or Register  to view this content.

**williamthomp** · 01-04-2013, 09:58 AM

AB33, Sorry for the late response..Forgot I had asked this question of the forum and out of pocket for a bit. I would rather the code be based on a macro that I run but I think I can fix that. My issue right now is I am getting a mismatch error Run time error 13 on If Target.Value = "þ" Then

Also not sure if this impacts it or not but the column font is a wingding that give me a check mark and I also have this double click macro on that column as well

Please Login or Register  to view this content.

**arlu1201** · 01-04-2013, 10:15 AM

Williamthomp,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

**AB33** · 01-04-2013, 01:38 PM

William,
The code can only be fired if you change the value of column "G".

Please Login or Register  to view this content.

You need to change the row which has value "þ" and see if the code throws an error
Could you please post your book?

**williamthomp** · 01-07-2013, 12:46 PM

AB33..I notice that it is working. It does cut and paste it onto the new sheet..But it still stops and gives me an error code of Run time error code 13 " Type mismatch. Was going to attach the file but dont see the attach icon ..am I missing something?