I have one file with 2 different worksheets. Each worksheet contains a long
list of item id's. Worksheet 1 has 4,883 lines of data in column A.
Workshhet 2 has 185 lines of data in column A. I would like a macro to run
that will check each column for duplicate item id's and maybe color the cell
to identify the item that occur on both worksheets. I am a novice with
macros, so any help is greatly appreciated.
thanks,
Chris