Hello I am taking baby steps to learn power query. The big project for me is to do in power query what I used to do via the macro recorder. I have a query with the source a sheet in another workbook. I copied the sheet to my new workbook but I don't know how to change my source from:
Just the feedback sheet which is now in the same workbook as the query.
If this is any easy fix I appreciate the help. If it is complicated I would appreciate advice on a tutorial or website where I can work on learning what is needed. No matter what, thank you for your time reading this.
Power Query:
let
Source = Excel.Workbook(File.Contents("C:\Users\phillip.gwinn\My Drive\SCORECARDS\Copy of RA SCORECARD WORKSHEET.xlsm"), null, true),
FEEDBACK_Sheet = Source{[Item="FEEDBACK",Kind="Sheet"]}[Data],Just the feedback sheet which is now in the same workbook as the query.
If this is any easy fix I appreciate the help. If it is complicated I would appreciate advice on a tutorial or website where I can work on learning what is needed. No matter what, thank you for your time reading this.
