stefanoste78
Member
Good morning.
I have 2 folders, for example the folder "a" and folder "b" and in each of these folders I have files with different names but which can correspond as names to the other folder (Inside the files can have the same lines or more lines ).
How should the macro be if I want to merge the files with the same names and then delete the duplicates (the same lines) within the created file and save the file obtained in a third folder with simultaneous deletion of the merged files in the two original folders?
In practice I saved the files for in two different folders as I updated them and now I want to get a single new folder with all the data entered in both.
The table headers in all files are the same
Thank you
I have 2 folders, for example the folder "a" and folder "b" and in each of these folders I have files with different names but which can correspond as names to the other folder (Inside the files can have the same lines or more lines ).
How should the macro be if I want to merge the files with the same names and then delete the duplicates (the same lines) within the created file and save the file obtained in a third folder with simultaneous deletion of the merged files in the two original folders?
In practice I saved the files for in two different folders as I updated them and now I want to get a single new folder with all the data entered in both.
The table headers in all files are the same
Thank you