I would like to know if there is a way to compare two workbooks and have the data that is the same from the new data workbook replace the data in the master workbook.
Right now I cut and paste but the new data workbooks are getting longer and longer.