copy data from three columns to another worksheet according to criteria

[marreco]

Hi.

I need to make a change in my file.
The labeled cells in yellow will be transferred to the sheet "sk", based on the column "B", which includes lines with "SK".
Once transferred the lines where stated "SK" lines should be cleaned and not excluded.
I did the simulation of line 8, as if he had been transferred to the worksheet "sk"

Thank you!!

[patel45]

Please Login or Register  to view this content.

[marreco]

Hi.
was great!!

if possible, could you explain (commenting lines of your code)?

Thank you!

[patel45]

Please Login or Register  to view this content.

Note.
when you provide all informations, file included, we can solve quickly