Power Query: Get data when sheet/Table names change (2 ways) | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Check out the blog post★

★ About this video ★
Power Query gets the sheet or Table data from an Excel Workbook based on its name. So when source systems produce inconsistent names it causes errors.

We don’t want to update the query, and we don’t want to edit the workbook. Instead, how can we get it by position? That’s the problem we are solving in this post.

0:00 Introduction
0:43 Example Data
1:43 Understanding the Navigation step
4:06 Solution #1: User interface
5:50 Solution #2: Write the M code
7:27 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel

[Dan_De_Man]

Nice. You said 3rd Table from 3rd worksheet. Did you mean 3rd table from 4th worksheet as info is first worksheet

[aniljaggarwal]

🙏 thanks
I have many excel workbooks and they do not have if tables. How to overcome this situation where sheet names are changing? Please explain

[IvanCortinas_ES]

Excellent Mark. As always offering top quality information. The contents are very good. Superb!!!

[ExcelUnlocked]

Hello Mark, great video, it's always great to learn new things. Could this be dynamic, i.e. navigate to the last table in the last sheet (not position, in this case it's the 3rd table)? if there was more than three sheets/table, let's say 10, 15..., thank you,