Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
101
Views
Topic starter
Hi,
I am sure this has been asked loads of times but in a nutshell can you add a query to a workbook that pulls the data from all of the worksheets in it. The data is not is tables or named ranges.
I am sure I have actually done it in the past but can't find my file or remember how (if) I did it.
Thanks
Bax
Posted : 06/05/2023 10:34 am
Hi Bax,
The Excel.CurrentWorkbook function designed for this requires the data in Tables or a named range. The workaround, is to get the data from an external workbook using the approach covered in lesson 3.02.
Mynda
Posted : 06/05/2023 11:46 pm
