Last seen: Jul 3, 2025
I didn't say that you will have different HQ column names, what I said is that you should not have other column than HQ columns, regardless of the HQ ...
You're welcome. If works, there is nothing to review. Code is already using Unpivot Other Columns in order to handle any new possible columns, i...
Between Added Custom 1 and Added Custom2 steps, add a new column with this formula: =List.Sum([Custom][Count]) The full step should look like: =...
You can try visual basic coding. But... if you run the codes again, what you type in the output area will also be replaced, unless you have a code ...
Power query result tables should not be edited, each time you refresh the query will read the source and reload data, overwriting what you edited. ...
Indeed, if the ID's are not unique there will be an issue, there is a grouping step that will group all rows with the same ID. If you make the ID's un...
That happens in all versions, if you copy the sheets MANUALLY. Copying sheets in VBA is another story, the usual user interface automation is not func...
Hi Furqan, You can add the new column with this formula: if List.ContainsAll(Text.Split([Description]," "), {"New York", "Manhattan", "Times Sq...
Macros can do almost anything, but why just Macro? Power Query can do it much easier than coding, see an example attached.
Hi Michael, The error means that you are trying to copy a worksheet that already exists in the destination. You cannot copy Sheet1 from Book1 in...
Google might be leaking, but I can't understand your english unfortunately, total nonsense. I provided a fix, let us know if works for you.
"I state that here you could only expect the best of instructions, even of a personal nature." Can you please use google translate? What does thi...
Hi Maurizio, Your profile is next to ALL your messages, saying your name when the profile is next to your message is redundant. You're welcome anyt...
Hi Maurizio (by the way: we all know your name is Maurizio, after 159 posts 🙂 ) Attachments.Add is an Outlook instruction, it simply cannot be use...
Not following what you mean. Can you please try again with more data examples?