I have an enormous amount of item numbers that is growing constantly. I want to be able to keep track of the new additions. How can I make a macro that will compare teh values in Column A of ActiveWorkbook, against those in Column B of "workbook.main.items" and insert the complete rows of any differences from ActiveWorkbook into workbook.main.items? I would also want it to identify those new items in the workbook.main.items.

Can anyone help?

Thanks
Tyler