Forum Discussion
Get the data from excel when Tab names change dynamically
Hi Anonymous
Please refer to the linked tutorial:
https://www.youtube.com/watch?v=JZSdAvGAq_EIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Anonymous
Sorry, I don't understand what are tabs, in your picture there are sheets...
The objects that I am familiar with in Excel are a workbook (the file itself)/ sheets/tables/columns.
What of those are dynamic in your case?This is exactly the case of the tutorial that I linked...
Reza shows how to handle the changes on the sheet names level.Anonymous
If I understand you correctly and you want the column's names changing automatically I in doubt that it is possible.But try to post it as a new question, maybe i am missing something 🙂
Super UserHi Anonymous
Sorry, I don't understand what are tabs, in your picture there are sheets...
The objects that I am familiar with in Excel are a workbook (the file itself)/ sheets/tables/columns.
What of those are dynamic in your case?
Hi,
Sorry I didn't use correct word.
yes it is Sheet(not tab) but the thing is sheet's names are dynamic over time.
As we know, if sheet names change then query doesn't fetch the data.
So I hope to make it to get data by sheet order not by sheet name.