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)![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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)
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)