Hi,

I have 2 long lists (up to 10,000 lines each) of serial numbers in 2 different worksheets. The numbers can have duplicate in the same column and also in the other worksheet. I would like to have a VBA code to extract all distinct values from both lists in the new worksheet and have them sorted in ascending order. Have tried with INDEX formula but it makes the workbook working very slow as there are too many records.

Thanks for any support,
Eduard