Excel automation(sheet cpmparision)

I have two excel files…
If daily sales store of 1st sheet matches with CV_OLD_STORE_NAMES of 2nd sheet then I want to replace 1st sheet Daily Sales Store values with 2nd sheets NEW_CODES


Can You Drop the input data


yep…only the names to be replaced with CODE number
CV_old names_new codes.xlsx (8.6 KB)
CV_first_file.xlsx (9.2 KB)

Hi @Rohith_Kumar1

please find the attached code

Practice3.zip (1.7 KB)

I appreciate for the time but I need something else …Can i have your number ?
so that i can explain u in a better way !!