Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
17
Views
Topic starter
Hi, thanks for the help
I have 12 sheets in the attachment and I need to attach them to one sheet
And run Unpivot to sort the months.
To do this automatically - I ran - a new query from the file
And I wrote in the formula bar in Query
= Excel.CurrentWorkbook ()
As I learned in the course I purchased from you.
But it does not work for me here in the file.
Why?
Thanks for the help, Leah
Posted : 06/01/2022 10:52 pm
Hi Lea,
Excel.CurrentWorkbook requires the data to either be in a Table or named range. It cannot see unnamed data. If you don't want to name the data, you can use this technique.
Mynda
Posted : 06/01/2022 11:20 pm