Use Power Query to Extract and Filter Data from Other Files | Everyday Office

[@goplex1]

Very nicely explained! Helped me a lot😀

[@Roger-mg8zh]

Exactly what I needed :-) a big thanks !

[@Jiyaaurhiba]

Nice Work 👌

[@kapilkaushik7866]

Wow! this is an amazing feature. I can use a common data source for my monthly reporting. What's your suggestion if I have to bring in filtered actual, budget, and forecast data from three separate worksheets? Three separate connections? There separate tables and then manipulate in profit & loss format?

[@runeelli]

can you make a video on how to use the All transaction 2010-2019 as a base/database source. and open a new fresh workbook, with the same headers. But if you type in the product id in the blank sheet. all the other colum autofills with the corespondent information. I.e you are going to pull out 200 lines from the source sheet. into a new sheet. with just typing the product id into the blank sheet.