I want create a macro which can
compare two different excel Workbook.
Take a text from one excel and search the other.
If found that textdata, update the changes in first excel.
Example : Execl1_OLD:sheet have Customer ID, Name, Age ,address as column Name
Execl2_New : have same data Customer ID, Name, Age ,Address as coulumnName
Take one Customerid from Execl2_New and search in Execl1_OLD if data found update the same in Execl2_New