How to sync workbook1.sheet1 with workbook2.sheet1 with VBA. Please note that workbook2.sheet1 is same as workbook1.sheet1 but workbook1.sheet1 will be updated by user. The updated data in workboo1.sheet1 need to be synced up with workbook2.sheet1 for all columns that has data.
Bookmarks