I have 2 folders, both the folders will have same number of files. I need to merge the file(s) of folder2 with folder 1 file(sheet1 only) but need to identify the same files.
Please find the naming convention of the files. Need to identify both folder files based on code(20,30,40,45, etc)
Need to pick (ABC - 20 - XXXX) from folder 1 and find out 20 keyword contained file in folder 2, Merge the file of folder2 in file of folder 1 sheet1 . Same for all files in folder 1
Ex:
Folder1 Folder 2
ABC - 20 - XXXX Mop - 30 - mmyy
ADF - 30 - XXXX Mop - 40 - mmyy
QWE - 40 - XXX Mop - 20 - mmyy
