Forum Discussion
Power Query Simplification
I have a series of power queries that are almost identical. Each has an input table from an Excel Sheet, and and output that is a new Sheet in the same workbook. Query one gets data from Named Ra...
Power Query can't create new sheet, and we can't say to Power Query by parameter at which place of the workbook to load it. This part of the job is more is for scripting tools or VBA.
If with Power Query we may manually create 30 new sheets, write core query/function which transforms source range into output using source name name as parameter. When write 30 queries with text like
let Source = core(name) in Source
and load each of them into proper place.