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