You can give the user the flexibility to pick the columns to import from the data source each time he or she wants to update a report. The solution explained in this video is very easy to implement! Get Power Query ready to handle that request. It is a very simple trick that you only have to set up once.
---------
Get access to the exercise files by joining our Telegram Group at: https://t.me/celiaalvessolveexcel
Subscribe our Newsletter for exciting news about the Excel world: https://bit.ly/learnfromcelia
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca/
LinkedIn: / celiajord ...
Facebook: / solveandexcel
Twitter: @celia_excel Instagram: @solveandexcel