queries

  1. E

    Question about filtering a table from a query through VBA - Dates

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

    Copy data from one table to multiple table.

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

    Dynamic Table Lookup

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

    Less than 6 month,6M to 1 year,1y-2years - Function With Payment & Receipt Days

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

    Access to access, is query the best option?

    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!
  6. D

    Code looping twice

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

    Query to two Access databases

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

    Power Query not loading data - Stalling

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

    Copy worksheets to new workbook, delete connections, then save new workbook

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

    Report Queries Back End vs Front End

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

    Queries - Super Quick Question

    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~
  12. D

    Run many large update queries in the right order one at a time possible?

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

    Extract Query Text from multiple Excel Files

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

    Is this merge possible in PQ?

    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?
  15. B

    Updating several web connections with queries in blocks with dependent data

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

    Query error with aggregate and criteria

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

    Speeding up 900 Simultaneous Web Queries

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

    Is this RAM/memory efficient?

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

    Excel Native Query Unlink/Refresh problem (BUG MAYBEÉ)

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

    Show Duplicates Across 2 Queries

    I have 2 queries: Both Queries have the same fields and are based on the same table (tblBusinesses) but have different criteria <tbody> Query Name Criteria OpenBusinesses 'Status' field equals 'Open' ClosedBusinesses 'Status' field is not equal to 'Open' </tbody> Is there a way to find...

We've detected that you are using an adblocker.

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.
Go back
Back
Top