queries

I am trying to evenly assign work amongst employees based on their availability and language. Please help, thank you very much in advance.

I have the following macro: Sub FilterByDate() Dim targetDate As Date Dim wsDashboard As Worksheet Dim wsShippingQ As Worksheet Dim tbl As ListObject Dim colNum As Integer 'Define the worksheets Set wsDashboard = ThisWorkbook.Worksheets("Dashboard_Today") Set...

Hello There. so in short: populate data from one master table (with 'variable structure') to multiple tables. in long: I have one table: data_src. with column/headers like this: tbl1$col1 | tbl1$col2 | tbl1$col3 | tbl2$col1 | tbl3$col1 | tbl3$col4 | tbl5$col2 | tbl5$col7 | ... |...

Using google sheets, is there a way to look up a value on the vertical & horizontal axes between two numbers? If years of service is 2.8 and company growth is 18.8, how can a lookup formula return 10%? We are rounding down on both years of service & company growth. Company growth: greater...

How to get an age-based report in Excel if the client does not have a bill-by-bill report. I need a formula for the first invoice against the payment setup, with the balance indicated as the Following Less than 6 months 6 months -1 year 1-2 years Query Sheet ABCDEFG1MNK TRADING...

All, What's the best way to bring data from one access file (user-oriented) to another one (main database center)? I tried using Append Query, but it adds all rows and not only the ones that are new. Moreover, it seems to be a manual process rather than an automated one. Thanks!

Hi friends, I am stuck in a VBA problem. actually, the code is printing the value twice in subsequent rows its working fine on my previous excel version 2007 but now I shifted to office 365 and its printing the values twice whenever the cell changes. Attached photo for clarification see timing...

Hi everyone I'm working in a code that need retrieves data from two Access databases, but unfortunately it doesn't works What the matter? Dim cn as adodb.connection Dim Qr as string Dim rs as adodb.recordset 'Opens the conection set cn = new adodb.connection with cn...

Recently I have had both relatively small power queries (180 rows, 10 lines of M code) and larger (approx. 6000 rows, 25 lines of M code) stall at the load stage. It happened first with the larger query and I thought it had to do with the size of the query. But it has now happened with smaller...

I am trying to copy two worksheets to a new workbook and rename/save that new workbook. When I copy the worksheets over - the queries are copying with it...which is causing issues when I try to save the new workbook. To get around this, I am having to delete the queries / connections...then...

Hello All~ I created and administer an MS Access DB. Back End sits on a Network Drive, 20+ End Users have the Front End on their respective Desktops. The Application has a Reporting Tool where the user has the option of selecting and running about 20 or so different reports. Currently I keep...

Trying to decide how to present something to my client and this question came up since I'm brand new to Queries. Say Your Master table is on one sheet and you have a query on Sheet 2. Is there any way scenario in which a person could change a cell in the Query and it updates the master? ~Todd~

My database is 4 million records and when I import the new data every week it's a mess because the source people are idiots. SOOOO, I created a long list of update queries that find the things that should not be there and eliminates them. Each query takes about 90 seconds to run - there are...

I've struggled to find answers to this online, as most of the results are for extracting the DATA, but we're in the midst of a project that will require changes to a large number of queries that have been written in Excel Documents. What I'd like to be able to do, is run something that can...

Hey folks, Suppose I create two queries for the two tables in my spreadsheet https://1drv.ms/x/s!AvjBsEPEq12ngTmYWfZW_bAjU4w7?e=9d2PBI Is it possible to somehow merge them as per my example?

I'm trying to update several connections in 2 blocks, the connection of the second block required data from the first block as input. To update the connections the user had to click on a button which starts the web data update process. During the update process a message is displayed (with a...

I'm trying in a single query to exclude variances of $0 using data from 2 tables. I create a temp table from 2 queries and query that with aggregates and criteria. <code> SELECT x.Vendor, Sum(x.Budget) AS Budget, Sum(x.Actuals) AS Actuals, [Budget]-[Actuals] AS Variance FROM ( SELECT Vendor, 0...

Hello: I currently have a spreadsheet that is pulling pricing information from the Internet in 900 queries. Currently, each query returns a 4 x 7 table of data assigned to a unique worksheet. The problem is that it is taking 1 hour, 20 minutes to update. So far, I have disabled the...

Suppose I have a workbook which has one sheet with a table (say Table1) of 20,000 rows of data. If I create a new workbook and use Power Query to create queries by sourcing Table1, does that make my second workbook for memory efficient to use? That is, dumping data into one workbook. Then...

Hi, I have a problem with the NATIVE Excel Query as follows: I have a master file that contains 5 queries loading data from 5 tables on 5 different files on a SharePoint site. I also have a MASTER QUERY that combines these 5 queries into one Master Query. All work fine when it is all...