Hi again.
I have several folders each containing the same identical set of excel files, where every folder stands for a specific lab.
I have another folder that contains one excel file that should import data from the above folders and place it sequentially one below another.
I can basically import one spreadsheet at a time from the menu's Import Data tool, but that will take me a decade, and I'm not so sure what would happen if I decided to change the folder structure.
So, is there a way to automate the procedure?
Thanks,
Ron