Excel Compare Cells Between Workbooks
I would like to create a macro that compares cells within Column E and if they are found to be matching then it would check/compare the date fields in Column H and the oldest date the macro would mark "yes" in Column R.
I'm newer to excel and not sure how to do this.
Assuming that you are creating a formula on Book1 to compare to Book2, then put this formula in Book1, Column R
Obviously you would need to change the Book Names and Sheet Names.
What did you mean by "Oldest Date"?