Macro copies row based on a cell data but leaves blank rows between them.

Hey all, I have an Excel Sheet that I need to copy the row to another sheet if one of the cells contains specific text. I have found one that does just that, however, it copies it to the same row that it is on the other sheet, leaving me with blank rows between them. I would like them to paste into the next blank row starting with row 2 (row 1 will have headers in it that match the headers in sheet 1 where it is pulling the data from). I have put below the macro that I am currently running and have attached a copy of the workbook with that macro for reference.

If row F cells contain "D1", the entire row will copy and paste to the next blank row on sheet 3 (named D1)

Please Login or Register  to view this content.

Hallo ...

In future please view the forum rules before posting. Your post does not comply with rule #3.
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing.
So, do the following:
Edit your post, highlight your code and click the [#] button at the top of the post window.

Thanx JesterGrafix ...
Help you now we can ...

Please Login or Register  to view this content.

No need to quote entire posts ... Only you and I here at the moment ...
Assuming your sheets are already created...

Please Login or Register  to view this content.

...........................................
Thanks.gif
....Pls Mark Thread As Solved....