Hello,
We have three xlsx files with data ("file 1", "file 2", "file3") and one "All" file located in the specific folder/location.
Each of the file is password protected.
Files "file 1", "file 2", "file3" contain data stored in 3 the same columns: name, surname, date
To achieve the goal, the data from these files ( "file 1", "file 2", "file3") should be transferred to the "All" file (columns: name, surname, date) automatically and the password protection cannot be removed from any of the files. The "All" file has to be refreshed of the new data from "file 1", "file 2", "file3", each time when it is opened.
How to consolidate "file 1", "file 2", "file3 into one "All" through a macro?
Thank You.
Bookmarks