Copy & paste a row (without leaving an empty row behind!) if a cell contains a value

Hi all!

I have 2 worksheets, one called "Consolidated" and one called "Converted".

I would like to have a spreadsheet where I press the update button and a macro runs that searches for the word "Converted" in column E on the Consolidated spreadsheet (the original). When it finds it, I would like the entire row to be cut and pasted onto the "Converted" worksheet.

I have managed to do this with my current code:

Please Login or Register  to view this content.

However when this macro runs, the row left behind on the original sheet is a blank row and I don't want this. I would like it to be continuous spreadsheet, not dotted with random blank rows!

If anybody can see a solution to this it would be greatly appreciated!

Thanks!!

You need to loop back ward if you wish to delete(cut) a row.

Please Login or Register  to view this content.

Hi AB33,

Thanks for replying! I tried the code but it seems to be breaking on this part:

Please Login or Register  to view this content.

Thanks!

Sorry! My bad!

Replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

One line

Hey - did that! Unfortunately it is the same result as my code - the blank rows are still left behind on the original sheet

Please attaché a sample

Try these lines

Please Login or Register  to view this content.

Awesome that line of code worked! Thanks so much!