query

Hi all, I've searched around but can't find any instance where this problem has been solved. I've got some queries set up in Excel (2016) that get stock data for the day from a website. Typically I'll open the workbook and hit refresh all, and the data loads. Today, though, it's loading...

I have a spreadsheet that is basically a trimmed down version of my master that gets distributed. To trim it down, I have removed columns and implemented conditional formatting for readability. Needless to say, very complicated (mostly due to the conditional formatting giving the reader pretty...

Hi everyone, I have a query table in my spreadsheet. I added a column and put "No" in every row (See attached picture for a simplified example). So when the query is refreshed and add more rows, new rows will also have "No" as their starting value. And that's exactly what I want. Then when the...

MS Excel 2016 This is the first time I've used a query, so I could very well have constructed the applied steps incorrectly. My problem is that records from newer files are not present. The query is designed to compile lists of reviewed records from weekly reports. They are the same lists...

I would like to use our case details listed on a spreadsheet to allow staff to enter one or more criteria and have the details of all relevant cases show up on another tab. I have attached a sample of the type of information recorded. If possible, but not a requirement I would like to query...

I have a Query that includes a column with list of last names, i.e. Smith, Jones, etc. In my worksheet there is a named range of Week_Smith, Week_Jones, etc and this named range is a single cell, which contains a date. I would like to add a new column to the Query to return the named range of...

Hello, I have a quite intense (some may think its pretty basic) excel document, which shows information within it that I am looking to condense into a pivot/vlookup basis. There are multiple sheets (within a workbook) - so i am trying to have a 'link' feature to do this correctly. its also...

I run an SPC chart with a power query created table that tests results against Nelson Rules. The samples runs fairly quickly, so I have the Refresh every set to 2 minutes during the day. The refresh triggers a Worksheet_Change event that checks the timestamp of the most recent run, to the...

File link: Gofile Hi, I am pulling in 10 tables from William Hill (bookmakers) with all the English Premier League anytime goalscorer odds. Part of this process includes tweaking the data in the 'edit' mode which I've detailed below. However, when the gameweek is over, the tables are updated...

I have the following cell data. A2 = 108.59 B2 = 20% C2 = 27.15 C2 has the following formula in it: =A2/(1-B2) - A2 this gives me the 27.15 What I want to do is have in D2 a hard value of 23.00 and then in E2 I want the % value based on the formula in C2. IE - If C2 was 23.00, what would B2...

Hi, Looking for some help with some VBA - I'm a beginner with it so it's much appreciated. I have an Excel workbook with a number of queries on different tabs that refresh when I click Refresh All (and Excel handles these in the right order for the final Merged Query), but the Pivot Tables...

Hi All, I have a MS SQL stored procedure returning data to excel. After retrieval I carry out some actions using a macro. When I run the query and then run the macro, the macro takes a long time. If I run the query save, close and reopen the workbook and run the macro first, then it executes...

Good afternoon, Please could you advise where i would put the following array: {QUERY;{"TOTAL",SUM($E$5:$E)}} ...in this query: =IFERROR(QUERY(IMPORTRANGE("sheetname","INVOICE_ENTRY!B2:J"), "SELECT *" & IF ((LEFT(G4,1))="*", "WHERE Col7 STARTS WITH '"& RIGHT(G4,LEN(G4)-1) &"' AND Col1...

i All, In English, I want to populate the cell J4 based on the table value (see attached image) If cell IA = WDDS the populate with table WDDS value 6:00 If cell IA = WDAS the populate with table WDAS value 12:00 If cell IA = WDNS the populate with table WDNS value 20:00 If cell IA = WEDS the...

Hi All, Is there a way to retrieve in VBA the latest refresh date / time of a query ? Thanks!

I'm working on a spreadsheet for our inventory. The inventory is pulled out of a SQL database called Inventory. The retail price field is called PriceRetail and the wholesale price field is called PriceWholesale. The table starts in cell A6. I have a dropdown in cell B3 so I can select...

Tyring to build a report that shows Organization and position that people are in. For example: There is a table that shows all employees (admin) and them in the respective positions Sort ORder Org Big Boss Manager Worker 1 South Group me 1 South Group vacant 2 North Group Tom...

Good day, everyone! I'm in an environment that is running two different versions of Excel. Excel 2016 and O365. I developed a utility which has three data connections to other Excel files, and these data connections are causing me issues. In Excel 2016, I've recently discovered that when a...

I am trying to fetch data from my oracle db using excel VBA. I have made the connection and successfully fetching the data, however my data containing japanese character is broken. It became something like "A14 ｿｿ: ｿｿｿ ｿ ｿｿ: ｿｿｿｿ (ｿｿｿｿｿ)" I wonder why my data containing japanese character is...

Hi there to all Mr Excelssss men. Ok, i know we can type an sql query and bring data to our excel. What a want to do, is to type something, which in this case is an Invoice ID number, and that triggers sql query and give me back some fields. I actually have the query that brings all the records...