Stacking excel data from folder

Hi Anonymous,

If you go to the connections options and select From folder then jus select the file you want to edit.

This will create a function that will allow you to make all the changes on your base file that will be repetead on all the files and an append of the files.

So you just need to had the files to the folder and after the refresh the data will be stacked with all files.

Regards
MFelix

Hi Anonymous ,

 

Can you please mark the correct answer in order to help others that are looking for same question.

 

Regards,

MFelix