Forum

Hi Nick, Can you please clarify why the item below should be 1? That seems to be occupied in your example? 1044220 7560000 Should be 1 ...

Hi Daniel, Welcome to our forum. Can you please upload some sample file so we can see your data structure? There can be many ways to get the res...

Hi Jingjing, If you have a table with DOI strings, add a new column calling a custom function (built based on the sample query and pass to the func...

Hi Mani, Have you tried the code provided in your other topic? Should be very similar.

Hi Mani, Instead of writing complex codes, try the solution attached, all you have to do is to refresh the Report if there is new data in the sourc...

To Insert (copy) a shape from a file to another: Dim Pic1 As Shape, Pic2 As Shape, Sh1 as Worksheet, Sh2 as worksheet Set Sh1 = SourceWorkboo...

Hi Pieter, Here is my version of the query: let Source = Excel.CurrentWorkbook(){[Name="tblRawData"]}[Content], Roles = List.Buffer(Excel.Curr...

Hi Phillip, There are multiple ways to set a timeout: driver.Timeouts.ImplicitWait = 5000 ' 5 seconds As well as individually : driver.F...

Excel is not meant for image processing. Use javascript:

Hi Zara, Yes, it is possible. Is there a reason for doing that with a macro instead of a simple conditional formatting for that range?

Hi Gob, I'm afraid it's not possible, there is a sheet Change event but this event detects any change, it cannot make the difference between a manu...

Hi Glenisa, Hard to imagine how it should look, can you upload a sample file showing the before and after versions? thank you

Why not use a pivot table, instead of manually splitting data into tabs with formulas? You can use sliscers to filter data for a specific Region, or y...

Hi Damian, That formula does not work with a range of cells. All you can do is to use vba to convert the range to HTML, this is the format accep...

Hi, You have to put the shape name in the cell next to column BK and use the code below placed in the sheet Lower module. The code will fail if the...