Forum Discussion
Export Data From Power Query into Multiple Excel Sheets based on criteria
Please find here below the structure of the data I am working on, I would like to get some help to find a way that when I export the data from Power Query I am able to achieve 2 things. 1) The data ...
I have tried your code and keep getting an error 9 Subscript Out of Range
on this line
Set full_data_listobject = ActiveWorkbook.Worksheets("full data").ListObjects(1)
I have 1 sheet names full data and I have selected a column without the header name
Any Ideas
on this line
Set full_data_listobject = ActiveWorkbook.Worksheets("full data").ListObjects(1)
I have 1 sheet names full data and I have selected a column without the header name
Any Ideas
