Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I would like to know if it i possible for me to create a power query that will update automatically as the connections i have inputted into the query are updated with new data.
Solved by G. J. in 15 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 13/04/2018 - 03:56
Hi
Excelchat Expert 13/04/2018 - 03:56
Welcome to Got it Pro
User 13/04/2018 - 03:56
hi
User 13/04/2018 - 03:57
ty
Excelchat Expert 13/04/2018 - 03:57
When the connection that you input changes the power query will update automatically
User 13/04/2018 - 03:58
thank you
Excelchat Expert 13/04/2018 - 03:58
You are Welcome
Excelchat Expert 13/04/2018 - 03:58
Please let me know if you need anything else
Excelchat Expert 13/04/2018 - 03:59
I would be happy to help you out
Excelchat Expert 13/04/2018 - 03:59
Also looking for good rating and reviews from you
Excelchat Expert 13/04/2018 - 03:59
It really helps
User 13/04/2018 - 03:59
you got it!
Excelchat Expert 13/04/2018 - 04:00
Thanks
Excelchat Expert 13/04/2018 - 04:00
You will get an option to rate when you end the session
User 13/04/2018 - 04:00
would you be able to tell me step by step the best way to use the get & transform feature in excel 2016 to take information from other rep exel sheets and combine them all into a master
Excelchat Expert 13/04/2018 - 04:02
To use Get & Transform in Excel 2016, you create a query in your workbook. A query enables you to connect to, preview, and transform data from a wide variety of available data sources. You can then load that transformed data into a table, or into the built-in Data Model in Excel 2016, and even refresh that data later on. You can also edit the query whenever you need to, and share your query, too.
Excelchat Expert 13/04/2018 - 04:03
To create a query in Excel 2016, use the Data tab in the ribbon, then select the New Query button from the Get & Transform ribbon group.
Excelchat Expert 13/04/2018 - 04:03
Related Get & Transform features are also available from the Get & Transform ribbon group in the Data ribbon.
Excelchat Expert 13/04/2018 - 04:04
Looking at those steps in order, they often occur like this: Connect – make connections to data sitting in the cloud, in a service, or locally Transform – shape the data to meet your needs; the original source remains unchanged Combine – create a data model from multiple data sources, and get a unique view into the data Share – once your query is complete you can save it, share it, or use it for reports
Excelchat Expert 13/04/2018 - 04:04
Have look at this for step by step process
Excelchat Expert 13/04/2018 - 04:04
https://support.office.com/en-us/article/getting-started-with-get-transform-in-excel-2016-a8310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=en-US&ad=US
Excelchat Expert 13/04/2018 - 04:05
Let me know if this helps you out
User 13/04/2018 - 04:06
ok thank you so mcuh
Excelchat Expert 13/04/2018 - 04:06
Does this help?
Excelchat Expert 13/04/2018 - 04:06
Looking forward to good rating and reviews from you
User 13/04/2018 - 04:07
i think it will, i havent had a chance to test it out yet
Excelchat Expert 13/04/2018 - 04:07
Ok
Excelchat Expert 13/04/2018 - 04:07
It will definitely help you out
Excelchat Expert 13/04/2018 - 04:08
Have a great day
User 13/04/2018 - 04:08
you too!
Excelchat Expert 13/04/2018 - 04:08
Thanks
Excelchat Expert 13/04/2018 - 04:08
Do provide good rating when you end the session
Excelchat Expert 13/04/2018 - 04:08
it really helps
User 13/04/2018 - 04:08
I will
Excelchat Expert 13/04/2018 - 04:09
Thanks
Excelchat Expert 13/04/2018 - 04:11
You can end the session if you want

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.