hi experts
I have the right data in sheet MAIN and I fill data manually in sheet ENTER sometimes I make mistake or leave some cells and when correct manually it will take more time . so I search fast macro to deal with this data and in future it will reach at least 1500 rows .
it should match data between two sheets based on column B and search the wrong data in column C , D,E or missed values in some cells which contains empty cell or items are not existed in sheet ENTER based on column B with the right data in sheet MAIN in columns C,D,E .after correcting the data in sheet ENTER . it should highlight cells which contain wrong value by yellow color ,if there is cells are empty (this means missed some items) then should highlight by red color and if there are many items are not existed in sheet enter. just to understand how data show . it will bring them and highlight by blue color . the result should be in sheet ENTER . there is no sheet OUPUT and should highlight the data are existed in sheet MAIN and are not existed in sheet ENTER
I hope to I covered all of details without any confusing .
thanks in advance
Bookmarks