Forum Discussion
Excel Power Query
Two things... 1. I have a main sheet tab that takes information from 3 other sheet tabs in the same workbook and displays the data using power query. However, I also want to add additional free-...
Riny_van_Eekelen this, unfortunately, doesn't solve the problem for what I'm trying to achieve.
Effectively, what I am trying to create on Sheet A. is a bingo matrix for a sales team to see all of their accounts and what products/services they have. Sheets B, C & D have the technical information for particular products. My Power Query tab (Sheet A) is pulling through the customer name and a total column from sheets B, C & D. What I then want to do on Sheet A is add extra columns for information that the sales team can populate.
Farrah_Twigg Difficult to help without seeing the file. Hard to imagine what a "bingo matrix for a sales team" is. And as said, there are other methods to do such things in PQ.