Assistance needed in amending a macro.

[tweacle]

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.

Please Login or Register  to view this content.

Any Ideas?

Thanks

[JLGWhiz]

Unless I have misread your macro. it is comparing a value on sheet 1 to values on sheet 2. So if it shows Duplicate, in the display cell in column E of sheet 1, it should be evident that the item is also on sheet 1. Or maybe I have misread your objective.

[JLGWhiz]

In case you are wanting to check for more than one entry of items on sheet 1, this modified code might be what you want.

Please Login or Register  to view this content.

But it will add processing time to your macro.

[tweacle]

Sorry if I confused you but it spot on. Thanks