Having to repeat work is not fun or productive. Let’s see how we can transfer some of the work done in one query in Power query to other queries in the same Excel file.

Check the video of the question:
   • How to Copy a Power Query query from ...  

________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________

Chapters:
0:00 – Introduction
0:51 – explaining the problem
1:32 – how to copy steps from one query to another
5:22 – duplicating a query
6:36 – referencing a query
7:54 – breaking a query into two queries (extract previous)
9:50 – deleting the final query steps (delete until the end)
-----
Get access to the EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel
Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia
Boost your Excel skills with the best Excel books - Mr Excel Book store - https://www.e-junkie.com/ecom/gb.php?...
Learn how to automate your Excel Reports: https://snapreportschamp.com/


Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn:   / celiajordaoalves  
Facebook:   / solveandexcel  
Twitter: @celia_excel
Instagram: @solveandexcel
YouTube: https:www//   / celiaalvessolveexcel  

#excel #msexcel #exceltraining #msexceltraining #powerquery #powerquerytraining #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA