Comparing Two Sheets In Excel

Hi,

I have this problem I would like to combine “SanofiData” and “LifeSciences” together to only bring back the results that are only the same in both to another sheet in the workbook. I did this using a SQL Query and the data it brought back was correct but kept on breaking.

I would like this to be applicable to all workbooks not just SanofiData or LifeSciences.

Would anyone be able to help me code this using a Macro within Excel?

The Sanofi Data Sheet is bigger than the one attached but had to delete alot of data because of the size

Any ideas
Regards,
Jess

SanofiData has a lot of columns than LifeSciences. Which columns do you want to compare?

I would like this to be applicable to all workbooks not just SanofiData or LifeSciences.

Are the other workbooks in the same format as either of these 2?

The field to analyse the data is the Source ID to compare the two files as this is the same field in both documents and is unique. Then using this field I would like the Source ID, Title, Source Title and Year to be displayed.

The formatting throughout all the documents will have the same heading but I can make sure all the columns are in the same place as well if needed.

The SanofiData is the main data source and the LifeSciences is used to analyse the top 100 publications. As Source Title is a name of a Journal as there are many Titles which are the names of Papers that are published inside that Journal.

Hope this information helps, if needed I can attach a document to show what I would like the output to look like to help show/ understand what I would like to achieve using a macro.

Cheers,
Jess