Forum

I prefer to go for the Power Query solution already sent in the previous message. (Weather 7 days forecast.xlsx) All you have to do is to take the ...

Many errors indeed, mostly syntax errors, like WS=ActiveSheeet (note the 3 e) There is a reference needed in VB Project to Microsft XML . It's a...

Hope someone will have the time to help you, what you want is very time consuming and I can't help you, don't have enough time. There are many opti...

Hi Carolyn, The MySQL Connector is no installed, follow the link provided in that error message to download and install the missing connector. H...

Hi A.Maurizio, Your code will always add a new sheet and a new connection every time you use that button. Soon, you will have hundreds of connectio...

Hi, The line of code that writes Hours is disabled, uncomment it if you want it to write to table, see ModifyTableRow procedure. For Employee nu...

Hi Daniel, There should be no other limits than sheet rows and columns limits. When the code breaks, try to find if that specific sheet that fai...

Hi Hasnat, If you tried the solution found on web, inluding: Private Sub Workbook_Open() ActiveWindow.SmallScroll down:=1 ActiveWindow.Small...

Hi Guilherme, The source is quite irrelevant, data can come from anywhere, you can always add a calculated column. The formula depends on the type ...

Hi Janice, Add 2 more columns in the Group By section: the Item Name and Description. You can an add more steps after grouping: sort the results...

Hi Bill, If you always have numbers first, you can try this method: Add a new column with this formula: =List.Max(Text.PositionOfAny([Text],{...

Hi Tim, Use a table with multiple values to search, this formula for conditional formatting will do the job: =SUM(IFERROR(SEARCH(StringsToSearch...

Hi, On large data sets, even a simple formula will take a while to recalculate. You should aggregate data with power query, or even a simple piv...

Hi, Try the attached version. The initial code is not designed for so many variations and It's very hard to understand how it should be without man...

Hi Brooke, There is a bug related to sorting. Is the formula entered in 'Parking ' sheet? If so, remove the sheet name from this reference: 'Parking '...