millhouse123
Active Member
- Joined
- Aug 22, 2006
- Messages
- 335
I have a scenario that has about 150 workbooks each with different names, many with only one worksheet but all have different names but many with two or more worksheets. Of those workbooks with multiple worksheets I would like to only bring in the worksheets that have a 10 digit number in the worksheet name. In the end I would like to combine all the workbooks/worksheets.
I am looking for suggestions on how to use power query to bring in all the files - my first problem is that all the worksheets are named differently so when I try to combine by folder it errors after the first record since it can't find the worksheet name used in my first example.
I kind of envision a way to bring in the list of all workbooks and worksheets and then set up filters to keep those that meet that contain a 10 digit number. the expanding to combine all the data of these files. Just not sure how to do this.
Any thoughts on this would be helpful.
I am looking for suggestions on how to use power query to bring in all the files - my first problem is that all the worksheets are named differently so when I try to combine by folder it errors after the first record since it can't find the worksheet name used in my first example.
I kind of envision a way to bring in the list of all workbooks and worksheets and then set up filters to keep those that meet that contain a 10 digit number. the expanding to combine all the data of these files. Just not sure how to do this.
Any thoughts on this would be helpful.