find "windy" in col H, then move this row to sheet 2

[intothewild]

how do i find "windy" in col H, then move this row to sheet 2, got this far:

Please Login or Register  to view this content.

[Alf]

Based on your code perhaps like this?

Please Login or Register  to view this content.

I've added a "counter" so the rows pasted to sheet2 will be place beneat each other.

Using the "cut" command would leave "empty" rows in sheet1 to avoid that I've added the line

Please Login or Register  to view this content.

Alf

[intothewild]

perfect thanks Alf!

[Alf]

Glad to be of help and if you liked my solution click on the small star bottom left and give a rating to my answer.

Alf

[Alf]

Thanks for rep.

Don’t know if this is a problem but as macro works from the bottom of sheet1 going upwards.
So if one assume that cell H22, H15 and H8 all contains the word “windy”
The result on sheet2 will be that row 22 (sheet1) is now row 1 (sheet2),
row 15 (sheet1) will be row 2 (sheet2) and row 8 (sheet1) will be row 3 (sheet2)

If this is a problem I would suggest a fix like this using lRow as a counter:

Please Login or Register  to view this content.

Using the lRow property pastes the row to the same position on sheet2 as it had in sheet1
then the macro loops through the rows on sheet2 using the CountA function to find the empty rows to delete.

Alf