Hi All,
Hope you are doing great.
I have a problem where N numbers of SUB files will compare with Master file as per condition and will save new file.
Example : I have attached 3 Sub files and 1 Master file, All sub files are saved in a folder and master file is outside from folder. I have to open each Sub file one by one and compare with Master file with COUNTRY column where Sub files cells value is "YELLOW", if sub file compare value is lower then master file compare value then sub file value will overwrite on master file value and master file will be SAVE AS in same folder with that sub file name & "NEW".
Please help how to solve.
Hope you are doing great.
I have a problem where N numbers of SUB files will compare with Master file as per condition and will save new file.
Example : I have attached 3 Sub files and 1 Master file, All sub files are saved in a folder and master file is outside from folder. I have to open each Sub file one by one and compare with Master file with COUNTRY column where Sub files cells value is "YELLOW", if sub file compare value is lower then master file compare value then sub file value will overwrite on master file value and master file will be SAVE AS in same folder with that sub file name & "NEW".
Please help how to solve.