modify match column between two sheets with another and show the wrong and right items

[Ali-M]

hi
first I would thank for mr.jindon for the great assistance in this thread !
https://www.excelforum.com/excel-pro...lace-data.html
now I would modify the code by matching also based on column B ,but in this case after run the code and arrange data based on sheet MAIN should show the items is corrected in column D and the item is wrong in column E somtimes the error can be in first or middile or last item is wrong and somtimes there is missed items.
the missed items as in sheet result1 in last row . the item DM in sh2 is not existed but when arrange should be add in column D and not show in column E into sheet result1
as to missed items as in sheet result1 in first last row . the item DDTR in sh3 is not existed but when arrange should not show in column D and should show in column E into sheet result2, also if the wrong item doesn't contain space as in sh2,3 but it contains space in sheet MAIN then should consider error for the whole item which contain wrong space as in second row in sheet result2. the result should be in column D,E after arrange data in column C into sheet SH2,3 based on the macro
I hop what I ask for it . can be possible or logic espically if my result is not clear in sheets result1,2 . if it's not please guide me what the best way to do that .
thank

[jindon]

This is similar or almost identical to the thread

https://www.excelforum.com/excel-pro...her-sheet.html

Are you using different user names?

[Ali-M]

no , before I issued this thread I searched in this forum and I saw it and create like it . I don't find any thing , but you're right is similar .
is that problem if I create data like the others members ?

[jindon]

Because there are few users asking almost same question multiple times with the very similar data formats and I have very bad impressions on them.

That kind of thing makes one's volunteering spirits lose, in my opinion.

[Ali-M]

thanks. in the future I will add the link if I found similar question in this forum .