Hi,
I have an excel file that is 80mb in size. I have daily files for several years that I upload each day. I would like to see if I could save time by storing prior years already. They are csv file format 365 files x 4 years and take 30 minutes to upload each day.
I think if I could save...
Hi. I am a PQ rookie. If I have to change the name of a column is there a way to edit it all at once? I know in excel and vba I can do a control H and that gets me a find & replace dialog. But it doesn't seem to work in PQ editor.
If there isn't a way to do that, is there a way to export all...
I created 11 different tabs to be filled out. Is there a way to have the data in each of those sheets auto-populate into one master sheet? I need to show the totals of each product selected.
I only included the Master Sheet and 2 tabs below. Thank you for your help.
Master Sheet...
Hi
So I would like know if this is possible or if there was another way to do this.
I have a very large data source (750,000+ records) in an excel file.
I would like to create subsets of this data based on which team it is allocated to. This is the easy part for me. So I have Team 1, Team...
I wonder why in the normal Sumifs formula it will ignore the zero at the beg. of an invoice no., while sumifs in power query using aggregate won't ignore it
For Ex.
Sumifs between bank Data and ERP Data will show the below invoice as matching although in the Bank data the invoice doesn't have...
My question is this, is there a way to automate power query in vba, for example if I record a macro of me getting data from a PDF I open the pdf in power query I choose the option select multiple in the menu, I choose two pages and then I load it to a table. But when I go back to the macro, all...
I have been able to connect data to excel using publically available APIs and Power Query. Stuff like data from this page and an API like the equivalent downloads for UTLA API. I get data from a Power BI dashboard but they don't have a publically available API like the data above but copying...
Hi guys,
I hope everyone is doing well!
Just a quick question, I have a table on Sheet 1, with data that is populated using power query SQL source. My apologies if my question is a little confusing, I wasn't really too sure how to word it.
What I'm needing help with is somehow making it so...
I have a table with a customer and a bunch of line items tied to the customer, and then the next customer and a bunch of line items. Due to the way the information is received there are blank values between customers. I Have
CUSTOMER
PRODUCT
QTY
Customer A
ABC
20
XYZ
5
LMN
15...
I create a table (Table.A) from web source.
I want create table.B not from web source, but from exact data in table.A, so when refreahing table.B, it get content from table.A.
P.s: I tested connection reference, but every sub connections use Internet as source of data and just get structures...
I Imported some data from folder. folder has 100 txt file. I need select txt file based on names listed in column2 at sheet2.
Originally they are selected manually in power query and code is like that:
let
Source =...
Hello Mr. Excel Friends,
I have a few sheets linked to a master data sheet via power query. I had added some columns to the master sheet, but when I refresh the queries on the other sheets they do not update to include the new set (for example there was a table that initially had 23 columns...
Hi I am new to power queries. I am a teacher and try to accumulate all the score for the whole school.
I have 15 subjects and each subject have 15 classes to pull the score in.
My goal is to be able to receive all the subject scores for each classes(15 sheets in 1 excel).
Something like this...
Hi there.
SCOPE:
I have automatically generated reports that need to have 5 specific cells extracted from hundreds of workbooks, in multiple different folders. All values must be formatted as one row with the source information included, such as filepath and filename, into one master list...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.