Forum

These should not be in sheet modules, they refer to a form, but Me syntax represents the worksheet then the code is in a sheet module: Me.cbFilterS...

Hi Kevin, try: Workbooks.Open Filename:="https://1drv.ms/your_link_to_file"

Hi Ahmad, You should not add custom rows in a pivot table, this is not just unusual but also not recommended, even if there are some workarounds. ...

To your last response, see attachment. I added two steps after your code, in order to have amount in table. There is still something wrong with Sup...

Hi Trond, Sorry to say, but your suggestion neither solves the question regarding matching SupplNr, nor the problem with nested loop for Transact...

Hi Peter, The equivalent of excel's SumProduct in DAX is: SumX ( YourTable , YourTable[Col1] * YourTable[Col2] )

Hi Gray, If you want to define objects as CAcroApp or CAcroAVDoc, you need a reference to the Acrobat library. If you don't have a reference to tha...

You can use this step, assuming that PreviousStepName is a list of tables: = Table.FromColumns(List.Skip(List.Accumulate(PreviousStepName,{{}},(sta...

Hi Emanuelle, I checked the source data in your pbix file, and as you can see in the attached screenshot, those 2 entries are in february, not one ...

Hi Tan, You can convert the list to a table and expand only column 3, this will provide a single column result. Not sure what means appending to...

Hi Tan, Can you clarify please? Hard to see your structure. You have the list of tables in a list object? Or it's just in a new column in a tabl...

Hi Sherry, I am not sure why this is happening as I am certain this is a simple macro. What is happening? After SaveCopyAs just use: T...

Hi Trond, You can merge those 2 tables using as key the Supplier Nr. In the new merge column, you will have tables, with 0 or more rows, dependi...

Hard to say without a file. The answer is in your data, there is an operation performed in a column where nulls should be converted to logical befo...

Hi Robert, try this: With ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1).Points For Each Rc In Range("C2:C" & f) If Rc <> "...