Hi all,

in worksheet "test1" I insert new forms. I use cell a to g.
If in cell G2 to G1000 is an entry "share sale" I have to copy the complete line A to G
in another worksheet with the Name "Sale"´in to the next free line.

Have anybody an idea how to write this VBA?

Kind regards,

Thorsten