First challenge:
In a directory, I have "n" excel files. It could be dozens. Each excel file has the same name as a tab in a Central excel file. I managed to put all the names of these files in a List. Now I need to check if each file that is on the list is already a tab in the Excel Central file.
The second challenge is a continuation of the first challenge:
Open each of these files that are also tabs in the central worksheet and compare the content of each of these files with the content of the tab that has the same name in the central worksheet.
If a line from the file is NOT in the tab content (which has the file name), I have to copy this line from the file into the tab.
Now, if inside the Tab, there is a line that is NOT in the file, I have to delete this line from the tab.
I would appreciate the help. Yours sincerely