Being new to excel, I'm not able to write a macro which will update data in one of the columns from a master data reference.
For Example: I have a sheet (Tran_Sheet) which has transaction data, along with the first name and last name of customers as separate columns.
I got another Sheet (Master_Data) which has all the first names and last names of the customers.
The data in Tran_Sheet , has noise and garbage values, hence some of the names have been misspelled.
I need to write a Macro such that the names will be updated in the Tran_Sheet based on the Master_Data as refernce.
I know this is just simple using an SQL query, but I need yto do it in Excel 2013.
Thank you!!!
Regards, Ravi