Comparing two different excel files.

[rdelosh74]

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.