March 10, 2016
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.
Thanks for the help, Leah
July 16, 2010
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.