question

BrianMcMahon-6416 avatar image
0 Votes"
BrianMcMahon-6416 asked MiguelEscobar-3907 answered

Power Query - Variable loading location?

Is it possible to enter a formula into the existing worksheet location field so that tables will move their starting location when refreshed?

My client would like a file converted to a power query solution, but is asking for a portrait layout, even though the rows are highly variable.

129178-image.png


power-query-not-supported
image.png (21.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MiguelEscobar-3907 avatar image
0 Votes"
MiguelEscobar-3907 answered

You could use VBA to drive. I believe the article from the link below might be of help:
https://blog.crossjoin.co.uk/2015/06/10/power-queryexcel-2016-vba-examples/

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.