Copy Data if item does not exist on another sheet

[howard]

I Have a list of items in Col A on sheet4


I need a macro to the items on sheet4 in Col A after the last row in Col A on Sheet5 if these items do not exist in Col A on Sheet5


For eg is Ste01 is in Col A on Sheet4 and exists in Col A on Sheet5 then do NOT copy. If MTT001 is in Col A on sheet4 but is not on sheet5 in Col A , then this must be copied


your assistance in writing the code is much appreciated

 

[howard]

Re: Copy Data if item does not exist omn another sheet

Meant That :


I need a macro to copy items on sheet4 in Col A after the last row in Col A on Sheet5 if these items do not exist in Col A on Sheet5


For eg is Ste01 is in Col A on Sheet4 and exists in Col A on Sheet5 then do NOT copy. If MTT001 is in Col A on sheet4 but is not on sheet5 in Col A , then this must be copied


your assistance in writing the code is much appreciated