Hi,
I have a file name Book1.xlsx that has 4-8 sheets & I am trying & looking for a macro that will do the process as mentioned below,
It will match the column B data of sheet1 with column B of sheet 4 and if matches then nothing but if it doesn't matches then a msgbox should appear that data doesn't matches.
I am looking for vba macro to do the same
I have another file(book4.xlsm) in which i will put this macro & it is located in a different place
Bookmarks