Forum Discussion
Import data from excel files with specific file name into another excel sheet
Hi, I need a function/Macro that allows me to import data from files with a specific file name. More background: I am downloading a large amount of excel files from an webpage containing Agricul...
Hi, your first sentence could be achieved by using Power Query folder connection. 1. All files can be in a folder. 2. In Power Query use the Get Data/From Files/From Folder 3. Select Folder. then Edit the connection and Filter by file name for the files with the names you want. Then all you need to do is refresh the connection and it will pick up the files that match your file name filter. The only bit i cannot tell you how to do is the "...import data from specific cells". However once you have the files you want you can do wonders with the transformation features.