VBA to not copy data to other worksheet when it duplicates the item id

[tantcu]

Hello,

I have a macro code to copy new item from New Item List worksheet to Item Detail worksheet. However, I need any addtional input in the code so when it copy new items to the worksheet it will look up column C in that worksheet and if there is already a item in that spreadsheet it won't copy the item from the New Item List to the item detail worksheet but still copy other new items instead. Below is the code. Thanks.

Please Login or Register  to view this content.

[HaHoBe]

Hi, tantcu,

without knowing your data the autofill command isn´t really understandable for me so I commented that out.

Please Login or Register  to view this content.

Ciaom
Holger

[tantcu]

Thank you so much