queries and connections

  1. A

    Conditionally Extending the Reference of a String

    Hello everyone, I am currently working with a sheet that extracts data from a pdf that i upload using queries & connections. the string looks like this in cell B2 B2=IF(LEN(INDIRECT("Page002!C12"))=11,INDIRECT("Page002!C12"), IF(LEN(INDIRECT("Page002!D12"))=11,INDIRECT("Page002!D12")...
  2. J

    VBA - Loading Connected Data to Worksheet and then back to Connection only

    Does anyone have a VBA solution that would take a Connection only (Excel Power Query) and change it to a data table on a worksheet? And then the same in reverse, data table back to Connection only. I have a rather large file that I refresh each morning, and it includes an Archive Power Query...
  3. S

    Error when looping through Access queries "Too many client tasks"

    Hello friendly helpers, I have run into a problem when looping through Access queries via VBA. I have multiple levels that I am looping through; the first table (query) consists of unique project leaders, I then loop through these to find associated projects, after which i loop through the...
  4. 6

    Only reference first 3 columns of 'tableA' onto other sheets with larger tables

    The envision of a one-stop-shop tracker I have has one single master sheet, 'tableA' for all other sheets to reference. On every other sheet, I want only the first 3 columns the same, but the rest of the info in each table and each column name, to be different to show the respective info on...
  5. H

    Have Rolling 8 Week Data

    How can I have dates be on 8 Week rolling data but always start at a Monday? For instance this is what I did to get it to start from 8 weeks ago: But I would want it to actually start on 5/2/2022 because that was the Monday of that week.
  6. R

    Track changes on query

    I have a refreshable query table running in Sheet 1. In sheet 2, I have created a vlookup in columns A-H to bring in all relevant information from the table in sheet 1. Column I is where I write comments relating to each line. When refreshing the data, entries that are "closed" are removed...
  7. J

    Queries and Connections opens in single column that cannot be widened

    In an older thread, this code was recommended to open "Queries and Connections": Sub OpenQueriesPane() Application.CommandBars("Queries and Connections").Visible = True Application.CommandBars("Queries and Connections").Width = 400 'Change width as suits. End Sub This works sometimes for me...

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