Forum

You can unmerge all the cells in the column at once. If you need to specifically find merged cells, unmerge them and then populate them with the origi...

Set xMItem = xOTApp.CreateItem(0) should be: Set xMItem = xOTApp.CreateItemFromTemplate(mailTemplate) I suspect (hope) Outlook will not ...

Replace your current GETPIVOTDATA(...) section in the relevant formula(s) with IFERROR(GETPIVOTDATA(...),0)

Use IFERROR: =IFERROR(GETPIVOTDATA(....),0)

You also don't need separate loops (especially as one of them is a repeat of a previous one): Sub Copyfrom_Workbook_Another() Dim Wb1, Wb2 As ...

Sure - you can do something like this: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], RenamedColumns = Table.TransformColumnN...

You could do something like this: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Duplicated Column" = Table.DuplicateColumn...

If you want to test if the table is just a range on a worksheet rather than queried from elsewhere, you can use something like: If Activecell.ListO...

Are you sure you're using the same fields in the matrix in PowerBI as in your PP pivot table? Can't really tell much from those pictures.

You could do something simple like this then: let Source = Excel.CurrentWorkbook(){[Name="Matchups"]}[Content], #"Changed Type" = Table.Transf...

No problem - must have been gremlins. 😉

The syntax you posted is fine - where is the debugger showing the error point?

Hi, A couple of questions if I may: Does it actually matter what the group numbers are, as long as the grouping works? Also, do you actually ...

Please remember the forum rules on cross-posting and provide the links in future. Thanks. stackoverflow.com/questions/75895739/if-and-max-form...

I didn't say Table.ReplaceValue I said Replacer.ReplaceValue instead of Replacer.ReplaceText, which you are using now 😉 #"Step 1" = Table.Re...