★ 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 ★
Blog: [ Ссылка ]


Twitter: [ Ссылка ]


#MsExcel

свернуть