How do I read in 2 excel files and compare the data between them and then use that data to create a folder?

I currently have 2 excel files full of documents that I continually update with revisions. The excel files are records of documents for 2 separate projects that are progressing at different paces, but are essentially the same. The excel files have unique document numbers, a hyperlink to a pdf of each document, and a revision date. There are more columns with other data that isn't necessary to be considered. Therefore, I have 2 excel files with the same document numbers, but with different hyperlinks and revision dates.

What I want my program to be able to do is read in both excel files, find all of the document numbers, compare the documents and select the hyperlink of the document that is most recent. Then I want it to create a folder with copies of the pdfs of the most recent documents from each project.

Answer 1

[Image Analyst]

Try setdiff() or ismember(), along with xlsread() of course.

[Kenneth]

Could you elaborate? I'm not proficient at using Matlab.

[Image Analyst]

Aren't there examples in the help? Anyway, you didn't post any data. If you make it easy for people to help you (by posting the workbook), then perhaps someone may be nice enough to do it completely for you, though it would be good if you at least showed some amount of effort yourself.