If you want to follow along, you can get the files here. We start with a folder of Excel files (I also planted a txt document in there just for fun)Īll Files have a different number in cell C9 of a sheet called Special Sheet. This characteristic shall be now listed as “Characteristic A”. Is there any chance to pull the values from a specific range of equally looking Excel files (all forms) and list them?Įxample: The cell C9 of all forms contains one product characteristic. I will draw inspiration from the last comment posted bellow the post mentioned above that goes like this This requires a few extra techniques and some high level Power Query stuff, so I decided that rather than trying to fit it all in a comment section of that post, I would rather do an incognito blog post. Almost all comments referring to the mentioned blog post asked for exactly this, how do I do it with Excel files. This post is obviously not regular, since it’s not Tuesday (now I feel like Julianne Moore in Laws of Attraction) J but it’s a spinoff of a post I wrote in February of 2015 called Get Data From Folder with Power Query. So the final step of Get Data From Folder will have to use a function of more than just one parameter. ![]() ![]() There is a key difference here since Excel files are different than TXT files in a way that they can contain multiple Sheets and Tables. Whereas that post was about getting data from multiple TXT files within one folder, this one will tell you how to get data from folder full of Excel files. I recently posted on how to make a process of getting data from a folder bulletproof.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |