Copy entire row and paste to another sheet count clomn A

[dodde]

Hello

How can i copy entire row from row 19 to word "stop" in cloumn A in sheet Hurtig Calc, and paste it to row 19 in sheet tilbud EXC2, it must make new row if there and no emty

Can post wb if someone will help

[modytrane]

pls attach wb

[dodde]

Hello

Here is the wb

[xladept]

There is no "stop" in column A

[dodde]

Hello

it should have stand in row 23 in sheet Tilbud EXC2

[xladept]

Try this:

Please Login or Register  to view this content.

[dodde]

Hello

Thank you, the chalange is that it overwrite som rows my mind was that it make new rows so it push data below row 19 down

[xladept]

Try this:

Please Login or Register  to view this content.

[dodde]

Hello

i have tested and it seems like it worked perfect, i can not Add Reputation, because i did it in another tread, and not allowed twice, so a big Thank to you

[xladept]

You're welcome!

[dodde]

Hello

one little thing i try on another wb, copy from row 13, insert to row 25 but get error

Please Login or Register  to view this content.

[xladept]

What error?

[dodde]

Hello

error 1004, Application-defined or object-defined error

[xladept]

Because "stopp" is on row 19 then

Please Login or Register  to view this content.

The insert would be for negative 6 rows and we can't do that!

Try:

Please Login or Register  to view this content.

[dodde]

Hello

Everything ok , Thanks

[xladept]

You're welcome and thanks for the rep!