Dynamic copy/paste between Worksheets

Hi

I have an issue that I was wondering if someone could help me, or point me in a direction of what functions I can search for.

The case:
In Worksheet1 I have a table of materials. The columns goes from A to H, and the rows from 1 to infinity. In column K I have a number.
If the number i column K is greater than 0, I want the row from A to H to copy and paste i Worksheet2. So if I pick row 1, 3 and 9 from Worksheet1, I want them to paste into row 1, 2 and 3 in Worksheet2.

Heres an spesific example:
If K3 in Worksheet1 is greater than 0. I want C3:I3 to be copied to C3:I3 in Worksheet2.
If K9 in Worksheet1 is greather than 0, I want C9:I9 in Worksheet1 to be copied to the next free row in Worksheet2. In this case, C4:I4.

If something was unclear, please ask.

Regards
Glenn

One way

Please Login or Register  to view this content.

Or, if you want to run more than once without overwriting ...

Please Login or Register  to view this content.