Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
71
Views
Topic starter
I am trying to load from file folder 10-12 stock price files. I am new to power query and used the load from file folder. I was able to replicate the instructions but created one long data set. Is it possible to load to separate tabs?
Thanks
Ron
Posted : 06/06/2019 8:54 am
Hi Ron,
If you just want one workbook per query then you'd use Get Data > From Excel File. You'd have to create a separate query per file manually. Of course you could create one query and then copy it, then edit the file path to point at the next file and so on.
Mynda
Posted : 06/06/2019 5:55 pm
