Hi,
I am trying to compare a list with a list in another document. What I need to do is:
1. look at each cell in sheet 1
2. compare that 1 cell from sheet 1 with every cell in sheet 2, or at least a range of cells
3. Indicate by colour or 'true' 'false' that the alpha numeric data in sheet 1 has been found in sheet 2
Can anyone give help?
Many thanks,
F
Bookmarks