Consolidating a cell range from multiple worksheets - need final step

[mhagerman]

So I've been through multiple tutorials and online examples and I feel like I'm almost there but none of them have examples of using a range instead of a single value.

I have a directory full of 24 files and I want to do the automated equivalent of copying and pasting the same data range of C2:E10 from all 24 files into one table. Better still would be to copy only C2:C10 and E2:E10 (leave out column D).

How do I specify a range (not a named range) instead of a single cell reference when using Power Query?

 

[Matt Allington]

I suggest you do this
1 give a name to the 2 ranges you want to import In one of your workbooks
2 import a named ranges.
3 turn on the formula bar and Look at the M code. substitute the name with the range and see if it works.

Alternatively, import the sheet and navigate to the ranges that way.