Forum Discussion
Append files from a folder into a table
Must all of the worksheet names in a file be the same? I did a test and noticed that when worksheet names are different I get an error.
Probably depends on your Navigation step. Take a look at this:
https://www.excelguru.ca/blog/2014/11/19/combine-multiple-worksheets-using-power-query/
You should be able to use this technique to access the same sheet number (1st, 2nd, 3rd)
1 Reply
Probably depends on your Navigation step. Take a look at this:
https://www.excelguru.ca/blog/2014/11/19/combine-multiple-worksheets-using-power-query/
You should be able to use this technique to access the same sheet number (1st, 2nd, 3rd)