would it be possible say, if you had an excel file with 2 sheets, to loop around all the names in sheet 1, search search 2 for these names, and if a name is present in sheet 2, to tick a cell in sheet 1? for example:
sheet 1 looks like:
ID Name Address
1 J Smith England
2 B brown Wales
............................... and so on
and sheet 2 is the same, could one write a program that searchs sheet2 and ticks a cell beside the name of J Smith, if he is in it?
hope that makes sense,