I need to compare two different excel files.
File 1 is called "Robert Macro".
The data is located in B8-E38.
File 2 is user defined.
So far I have this:
MRB = InputBox("Type the name of the spreadsheet you want to compare")
I know, not much.
The data will be located in Column A.
If there is a duplicate between the two sets of data. I need the duplicate data in the user defined file to be highlighted yellow.
Thank you for your help.
File 1 is called "Robert Macro".
The data is located in B8-E38.
File 2 is user defined.
So far I have this:
MRB = InputBox("Type the name of the spreadsheet you want to compare")
I know, not much.
The data will be located in Column A.
If there is a duplicate between the two sets of data. I need the duplicate data in the user defined file to be highlighted yellow.
Thank you for your help.