Forum

Hi, Can you upload a sample file? There should be a criteria for these replacements, your message is not describing the logic that needs to be a...

Hi Todd,I sent a reply to your comment, thought you received it. You should call the procedure from another procedure, because the email address is r...

Hi Rosemary, The structure from the source seems to be different than before. You have to go to the Changed Type step, and remove the missing field...

Hi Chris, There is a very simple technique you can use for this. First, here is the query I used, I will explain it: let Source = Exce...

Hi Mark, The solution is simple: If you put in cell D2 a simple reference to P22 (=P22), you will be able to use that formula. D2 is not used, a...

Hi ER, All you have to do is to use HTML formats, to set up the message body font, color and other attributes. The following text will work in VB e...

Hi Mark, Please upload a sample file with your data structure. It will not work with the formula you mentioned.

Which version?

Or this one. Cheers, Catalin

Hi Jon, Hope you can use the attached layout.

Hi Jon, I did replicated the Excel Formula calculations in PQ, but there are no calculations there for how to detect the combined categories, that'...

Hi Jon, Only one category can be assigned to a customer, unfortunately. Its still possible I think, but requires a different approach, your sample ...

Hi Jon, I is possible, but you have to use a different solution, thinking in PQ is different than regular excel. I created a function to calcula...

Glad to hear you're happy with the solution 🙂

Hi Celeste, The code for refreshing a query is simple: Sheets("Sheet 1 Name").ListObjects("Table1 Name").QueryTable.Refresh BackgroundQ...