Copy entire row and paste it to another sheet

[Lukael]

I want to copy entire row based on cell value in column "F" and paste that whole row in another sheet - but paste in next blank row, starting from row 1:

Please Login or Register  to view this content.

Is that even possible in VBA or you must allways provide what row to paste ?

[davesexcel]

From the looks of the code, you want to if the target=1000 then copy the row to the first empty row in sheet("1000")

Please Login or Register  to view this content.

[Lukael]

thanks Dave, exactly what I needed. It's been a while since I used VBA, I see that I forgot a lot

[Lukael]

I'm sorry Dave but I tested again any noticed that this ins't solving my issues. I forgot to mention that I can't do code like you provided. I need to check worksheet name first, and then copy It to empy row:

[Lukael]

I'm sorry Dave but I tested again any noticed that this ins't solving my issues. I forgot to mention that I can't do code like you provided. I need to check worksheet name first, and then copy It to empy row:

Please Login or Register  to view this content.

This (a bit modified) code copies only one row. If I want to add another row, It just overwrites last one. How could I fix that ?

[excel_specialist]

I have previously made a template on this subject ,the row is copied to the sheet according to the value selected from the drop-down list in column H, and the row is deleted.

The used codes :

Please Login or Register  to view this content.

[Lukael]

I have previously made a template on this subject ,the row is copied to the sheet according to the value selected from the drop-down list in column H, and the row is deleted.

Thanks for response excel_specialist, but I allready solved It. What I neded was something different than yours:

Please Login or Register  to view this content.

With this I basically do a copy/paste from one worksheet to another, in different ranges.