Hi
Was given the macro shown below and what it does is compares data between sheets 1 & 2 and marks up on sheet 1 as duplicate/missing or OK.
What im trying to do is to run the missing /OK part of the macro but when its duplicated in sheet 2 I need it to show duplicate but if data is duplicated and also shown on sheet 1 i need it to say "duplicated and on sheet 1" and if duplicated and not on sheet 1 just show "duplicated"
Macro shown below.
Any Ideas?Please Login or Register to view this content.
Thanks
Bookmarks