Update rows from master workbook to all other workbooks based on ID

[bkrajeshkumar]

hi i have one Master workbook that contains several columns like ORDER ID,EMAIL,MOBILE,ADDRESS etc
i need to update field EMAIL,MOBILE in other workbooks which contains only ORDER ID.

Based on ORDER ID the every row has to be updated in all other workbooks,pls find attachments below
Am very new to excel macros pls help me out on this.

[sktneer]

Please find the attached workbook Customers.xlsm
The code is on the Module1 of this workbook. To make the code work, place Master.xlsx and Customers.xlsm in the Same Folder.
Open the Customer workbook and click on the Red Button on Sheet1 to update it according to the Master Workbook.

See if this is what you are trying to achieve.

[bkrajeshkumar]

Thanks a lot stkneer

[sktneer]

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.