Hello,
I'm trying to use Power Query Editor. However, it's the first time I'm using it and despite following some online tutorials, I have not gotten anywhere close to what I want to do.
Here is the challenge I'm facing;
What am I trying to obtain?
Note: I'm using columns grouping function in the masterfile...in case this has an impact
Thank you in advance for your help and inputs (preferably in an Excel spreadsheet please)
I'm trying to use Power Query Editor. However, it's the first time I'm using it and despite following some online tutorials, I have not gotten anywhere close to what I want to do.
Here is the challenge I'm facing;
- I have different vendor each reporting their sales/business objectives in separate Excel spreadsheets, all located onto the same OneDrive folder.
- I want to consolidate all their data into one Master Workbook. Basically I'm trying to establish a connection between this Masterfile and each separate excel spreadsheets.
- I'm just trying to establish a connection and retrieve the given number. I do not want to have a table format as a result of the connection.
What am I trying to obtain?
- in cell T5 (from the attached picture - IMG 4400), I should retrieve the number 480
- in cell U5 (from the attached picture - IMG 4402), I should retrieve the number 342
- etc..
Note: I'm using columns grouping function in the masterfile...in case this has an impact
Thank you in advance for your help and inputs (preferably in an Excel spreadsheet please)
