From the course: Excel Power Query Tips and Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Copy and paste queries to a new workbook

Copy and paste queries to a new workbook

From the course: Excel Power Query Tips and Techniques

Start my 1-month free trial

Copy and paste queries to a new workbook

“

- [Instructor] I've got this meeting attendance data and I have this table one query that you see over in the queries and connections pane. I did a lot of work to get it here. Let's take a quick glimpse at that. So, here are the steps. Under applied steps, you see what I did to get that result. Let's close that. Now, I want to apply that same work to this data. I am not going to do this work all over again. But what we can do is paste a query from one workbook to another. That's exactly how we're going to solve this and save ourselves some time. Highlight this query, right click, copy it, go over here, data, queries and connections, paste. Okay. We've got an error because that query is looking for table one. We've got to make a query in this workbook and point our query to that. So let's, inside our data set, get data from table slash range. All right. I'm going to close and load it. We see that the name…

Contents