Hello everyone
In the attachment I have two folder2 (FolderA & FolderB) and a workbook named "Mission" in which I need to put the macro
The macro would do the following:
loop through all the excel files in FolderA and transfer data to the same workbook name in FolderB.
The process of transferring data will not be once, it will be more than once .. so every time I ran the code it transfers the data to the first empty cell and so on
Note: the transfer of data from the workbook in FolderA to the same name of workbook in FolderB
I hope it is clear
Bookmarks