Worksheet transfer of non continuous range issue.

[skyping]

Good Morning everybody!

Really hope you can help me once again.

I have a 2 sheet Workbook which is designed to transfer information from one sheet (Goods_out_sheet) to another sheet (Goods_out_log).

I need to be able to use BOTH sheets to input data (one permanent (the log) and then to be able to print the other out for a paper copy only.

My macro (sourced a long time ago) does not quite function as I wish, as it transfers ALL the material in order across to the log sheet in order.

I have included in the attached file what is currently happening and below that entry, what I wish to transfer and the order I need.

Please note that the column 'headers' indicate the type of entry.....yellow being a formula generated result, red a drop down and light blue a manual input.

I think I'm not too far away from what I need, but I simply cannot seem to get this correct.

Hope you can help!

Skyping

[Artik]

It is enough to omit the unwanted column. I propose a slightly different code construction

Please Login or Register  to view this content.

Artik

[Sintek]

Another option...manipulating result...

Please Login or Register  to view this content.

[skyping]

Thank you Artik and sintek for your excellent solutions!!!

SOLVED

[Sintek]

Glad I could contribute...tx for rep +