Cut and Paste Macro

[japorms]

Guys,

I need some help again. I just need the rows which has the string from the inputbox to be cut paste to sheet2. Here's the code I have so far.

Please Login or Register  to view this content.

[Ikaabod]

Not sure where you want to paste in Sheet2, but here are two examples. The first inserts into Sheet2 at the same row that it is found in the activesheet and shifts all other rows down. The second cuts and pastes just below the last non-blank row found in column C.

Please Login or Register  to view this content.

[japorms]

It's doing the cut and paste fine but I still need the blank rows to be deleted.

Thanks for the code.

[Ikaabod]

Just add the line below after the row has been moved/paste:

Please Login or Register  to view this content.