select row if cell in column h is NOT blank

[rburnet4]

I'm trying to come up with a marco solution that will select rows if the cell in column H is NOT BLANK.

From there I think it will be rather easy to cut these rows and paste them in another workbook (that's filename does not change) at the end of the worksheet (in the first row that is completely blank).

Both workbooks only have one worksheet in them. Let me know what you think.
Thanks for all your help!!

 

[lenze]

Change

For r = 1 To nr

to

For r = 3 To nr

lenze

 

[machopicho]

This is perfect. One thing I did not think of though... How do I make sure the Macro does not pick up the first two rows (ie headers)?

For r = 1 to nr
...

Macro starts from first row
If you want to start second or third or...

For r = 2 to nr
or
For r = 3 to nr
or...