Hi
I was given this code by an old work colleague and he has now left and I not got a clue if correct as when I try and run it its not highlighting right across all the lrow
What is supposed to happen is the code go thru the NEW sheet and searches for the data on the OLD Sheet.
If the data is found, it highlights both rows Green and add Match Found on both sheets
In the data is not found it will highlight the row on the NEW sheet Blue and add Not Found.
What I also need to do if poss is the same but the other way round too. If the data in the OLD sheet but not NEW sheet I need it to highlight the row on the NEW sheet Blue and add Not Found too.
What I need it to do is go across columns b-e on both sheets. Can anyone confirm for me or be able to amend please.
Please Login or Register to view this content.
Bookmarks