I would like to request Experts help. Need to crosscheck data at Listing workbook (Column A) with Master Data workbook (Column A). If the same number exists in column A (Master Data WB), copy data from Column B to D (Listing WB) at column B to D (Master Data WB) at the row where the number exist.
If the number not available, copy data from column A to D (Listing WB) as new data row at MasterData WB. After copying the data, update cell at Column E (Master Data WB) with “StoreA”. Hope Experts will help me to create this feature. Attached the workbooks for Experts perusal.