Hello,

I have not been here in long time, I miss you all! Well, I've learned something new and excited to use it but I'm stuck.

Here is what I was trying to do. At work, I will receive a report with 3 columns - A, B and C (order number, delivery number and Reason code) The column for reason code is blank and that's what we need to fill out. It's about 200 rows at least.

Here what I do, I have a file with 3 columns A, B and C same as the report but with C filled with reason code. I use the Power Query, create connection with these two tables and get the reason code to show on the Report (Just like the Vlookup).

Now, my question is, for next month when I receive the report, do I have to create the connection again? If not, how do I use the query to click refresh?

I appreciate your help. Have a nice day and great weekend.