Hi,

I am trying to create a macro that can help to find duplicate serial numbers in my existing work file consisting of many sheets. and everytime there is a new sheet coming in, i need to compare the sheet against my existing work file with many sheets again.

if duplicates are found, can it be created into a new sheet?