Forum Discussion
Power query: Custom Columns
If you started with Power Query it's logical to do everything with Power Query. The only each time user added new sheet name Refresh All shall be done.
Not clear do you query other sheets or not, what is E13, etc, are other sheets dynamic (i.e. you add / remove them from time to time) or static. It's better to have small sample file or at least more detailed screenshots to discuss.
If you started with Power Query it's logical to do everything with Power Query. The only each time user added new sheet name Refresh All shall be done.
Not clear do you query other sheets or not, what is E13, etc, are other sheets dynamic (i.e. you add / remove them from time to time) or static. It's better to have small sample file or at least more detailed screenshots to discuss.
