query & connections

I have 2 workbooks. One is a Bill of materials (Bom) and the other is a master list (Ml). My bom takes the Ml as a connection, manipulates the data through power query and spits in on a new worksheet in the Bom workbook. I then open a new sheet (within the bom workbook) perform a vlookup and...

Hi all, I have data that I have been taking care of through Power BI and I need this data in Excel now. The easiest for me is to have this data in a Pivotable, so my aim is to create a pivotable in Excel with the data I worked on through Power BI. thanks ! N.B.: cross posted Create a...

Hello - I’ve been tinkering around with a sheet at work and I’ve been using various sources for getting data into a specific sheet so a group of 50 people can use. The best way I can query my data is through Microsoft exchange and applying filters to a specific email with excel attachments...

Hi all, I currently have a table of data containing customer orders; dates, names, stock quantities, customer order quantities, an IFELSE statement that shows whether an order is complete or not, etc. I have a Power Query set up that pulls the data from this table, and IF all of the orders for...

Hello all, I have a table (Query 1) which pulls data from an SQL server and auto refreshed every 2 minutes. This table has rows each depicting a single order with columns showing various information about the order (Value, Status, Allocation etc) In this table i have a column called "Last...

Quick question, Im trying to create a macro inside excel to create a new query. Upon running this macro, ( wich i created with record macro) al runs smooth. But transfering to a diffrent user, it prompts a warning and wants a username and password. No clue how to bypass this, because i...

So, when going to the "Data" tab, selecting consults and connections and mannually updating the connections they work flawlessly, but when (after recording a macro doing these actions) running a couple lines of code that do this action it throws an error message "[DataFormat.Error] Esternal...

I have been using an index match to pull data from a query to one of my spreadsheets. At first I was just having my query pull one day at a time so it was pretty simple. Now, I am having the query pull data from March till present and I need to index match my spreadsheet with multiple different...

I am working on a Classroom Files. Where i have many files containing report of each test like Test 1, Test 2, Test 3... I have to make a Master workbook that will contain the Mark Columns from All the Test Files I tried the PowerQuery ( I am very much new to PQ) but failed as it was...

Hello, I have a "source" Excel file with multiple columns to track jobs and of who took the projects. I have created queries to create a sheet in the workbook based on each person involved. For example, if the originator listed on the main page is "Joe" then there is a query page where Joe can...

Hi All, can't seem to find a solution to my problem. I have written a query that returns data from a database that is viewed in a pivot table. I use timelines and slicers to change what I am looking at, this works fine for one table and chart. I want to create other tables and charts also linked...

Heyy, I'm working on automating a system where we copy data from multiple excel workbooks into a overview workbook where we can analyse the data. The excel sheet are filled in by operators all over the factory using different versions of excel and the workbooks stay open on their pc's. At this...

Hello Team, I have a individual workbooks (each workbook share 3 sheets with same Sheet name, column names) in a shared folder/Onedrive. Requirement is to prepare the master workbook ( with same sheet name, column name ) with changes made in the individual workbooks should be reflected in the...