query

Hi everyone. I'm currently building a new order form for work and I've been asked to have one of the tabs auto-concatenate certain information from three other tabs - to prevent the customer from overtyping and getting it wrong. So I have four tabs:- Product A, Product B, Product C and Control...

I wrote a VBA code to download stock data from Yahoo Finance. To explain the bug that I discovered, I wrote the following VBA program. The VBA program downloads data for stock symbols SPY, XXX, and QQQ from the Yahoo Finance website and displays the downloaded data on sheet 1. Because the stock...

When making a query with multiple tables, a column called "Name" is automatically created, containing the table name... When appending queries, however, it doesn't do this. Is there a way to add a "Name" column to my appended query, so I can see which query the data came from? My queries...

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...

Good afternoon.. 1st Post: Helping out a friend with a mentor program, but I need help compiling live data from 100 sheets into one sheet. Here is what I have: I have 100 sheets in a Microsoft Excel workbook (saved to a OneDrive folder) that use identical column headers in each table. See...

Hi i am wondering if there is a way to refresh a group of queries using vba one group is called "Source data" or if that is not possible is there a way to refresh specific queries, some are connection only and others are tables example of queries: "filepath_New" "file_Path_Code_Old" thank you!

I have two tables. In the first table are the rates by resource (columnA) and the MonthYear (ColumnB-Y) In another table, table 2, where I have the resource (columnA) date MMDDYYY (columnB). I need for table 2 to look up and match both the resource and date from table 1 and return the rate...

Hi! I have a macro/vba that imports a .txt file (i wanted to be able to assign the macro to create a button to import rather than copy/paste), I just wanted pastevalues starting with a specific cell, keep the layout/formatting because its in a nice grid. I had it working fine for a week then...

Hi there, I want to create a table where a user can enter data for a 'Stock Alert Message'. The data entered will consist of a Stock Code, Group, Type and Category. I would then like to run a query against this table which will only show us Stock Items which have an alert. I'm struggling with...

Hi all, This might not be possible to do as I am unable to find a way to combine the information in a table into a Query to sort in a pivot table. Below is extract of my table columns A - G, rows 1 -15, etc It is currently in table format to produce a Query and Pivot Table, but what I would...

Bye all, I would like to add the query name as a column name in my Power Query. For example, the query name is "Cost1", so I would then like to have a column cell with the data "Cost1" at each row. Or is there any way to add the table name as the column name Is there any particular formula I...

I have this generic VBA code that allows me to load a query to a worksheet (by default I don't load queries to save time etc.) but it only works if I fill in the query name. But I want to be able to simply select the query and then run my macro (which will then fill in selected query's name)...

Hello, Looking for some guidance as I am a complete newb when it comes to PowerBI and Power Query..... Here is my dilemma I have a workbook that has 50 (US states) sheets plus 4 summary sheets I have written (with the help from Joe & Fluff) VBA macro that goes and looks at the cell color If...

Was trying to add a Z-score column and needed to calculate mean and median but I can't for certain columns with a large number of null values. Both columns are in the same merged query data source and are both decimal types. I can calculate statistics for one and not the other.

Howdy all, I just received a very extensive date sheet and I would like to pull only the lines of data pertaining to 2022 entries. There is a specific column which shows 2022 creation date. So, what I need to do is run a query or a sum= type of statement which pulls only those rows where 2022...

Hello, I've built this query on Access, there's about 13 tables linked. The total size of the db is only 2.3mb. The largest table has 14k rows and 70 columns (but not all of them are being used). So it's not huge and mostly runs pretty quickly when i run the query, but then when i add 3 more...

Hi all, I work tagging iguanas with unique combinations of coloured beads for field identification. I have a table with 13 unique values corresponding to these bead colours (for example Db is dark blue, B is black, R is red, etc.). When an iguana is given a bead tag the order/number of the beads...

Hi all, As recommended in another post, I converted my macros into a table-based Excel which includes queries. I am now facing a issue that I hope somebody can help with. I am trying to create a table that has both columns and rows dynamically updated. I managed to do this, but the content of...

Hello, I have a question regarding some DAX functions, What exactly does This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. mean? I presume the function has to be nested...

Hi team, Can you please help me find a solution to the below issue? I tried Vlookup, but it is really time-consuming. I have two sheets. One with the contact details and one with the product details. I want them to map it based on the account data. Sheet 1: Sheet 2 Result required ...