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

[@Computergaga]

Great as always Mark

[@ExcelOffTheGrid]

Thanks buddy 😁

[@IvanCortinas_ES]

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

[@ExcelOffTheGrid]

Thanks Ivan 👍

[@iankr]

Superb, Mark. Many thanks.

[@ExcelOffTheGrid]

You're welcome Ian. 😁

[@aniljaggarwal60]

🙏 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

[@ExcelOffTheGrid]

Exactly the same, but you filter on the Kind column as Sheet, instead of Table.

[@kebincui]

great vid as always

[@ExcelOffTheGrid]

Thanks Kebin 👍

[@ozgur937]

Thank you, very useful.

[@ExcelOffTheGrid]

I'm glad you liked it.

[@Dan_De_Man]

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

[@ExcelOffTheGrid]

Yes, correct. I’m not including the Info sheet.

[@everettlukacs]

Great help, thanks!!

[@ExcelOffTheGrid]

You're welcome!👍

[@johnhackwood1568]

First class Mark!

[@ExcelOffTheGrid]

Thanks John 😀

[@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,

[@ExcelOffTheGrid]

Yes, it could by dynamic. There are two simple ways I can think achieve that. - Reverse the rows (Transform > Reverse Rows), then use {0}. - Can also be achieved with a List.Count() function inside the {}. Depending on scenario it could even be 3 sheets after sheet called "Sheet1" etc. But that's probably getting digging in the very niche cases.

[@rhaps2008]

👍