Can you zip it and Ill have a look tomorrow
try when the in the raw data sheet run the macro the macros only work in the open work book and you may have deduped both lists