Last seen: May 22, 2025
Put the Set outMail =… line before the With outMail line.
Your IT department should be fired - that's pretty basic stuff. 🙂 You need to put this line: Set OutMail = OutApp.CreateItemFromTempl...
You have duplicate rows in the Sales Allocation2 COL sheet.
Remove this line: Set OutMail = OutApp.CreateItem(0) Do you not have distribution lists at work?
It would probably make more sense to do all of this in the original query, but you have removed the queries which makes that a little tricky. 😉
That particular dialog is for choosing a file, not a folder, and you didn't specify the InitialFileName property for the dialog anywhere. It w...
This part of your code to set the file name: Range("U23").NumberFormat = "mm-dd-yyyy" will return True/False depending on the numberformat appli...
You have a lot of the same calculations repeated in those formulas. I would move the lookups to a new row above the columns, and add the factored tren...
You can add that in like this: =IFERROR(AVERAGE(FILTER($D$2:$D$2382,COUNT(SEARCH({"assistant","supervisor","floor"},$C$2:$C$2382))*($a$2:$a$2382="s...
If you have the FILTER function available, you could use: =IFERROR(AVERAGE(FILTER($D$2:$D$2382,COUNT(SEARCH({"assistant","supervisor","floor"},$C$2...
Hi Alan, It would be: let Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID"...
When doing the replace values step(s) you should leave the 'value to find' box blank and put null in the replace with box.
Oh yes. I hadn't spotted that the values in columns D:I depend on the values in columns J:S of the row above. I think this should fix the problem: ...
I'd guess it's a floating point issue. You could also use Number.Round(([End]-[Start])*10+1,0) directly within the List.Numbers function.
I think this works: K19: =IF(ROW()<MATCH(K$7,$H:$H,0)+9,"",IF(MOD(ROW()-MATCH(K$7,$H:$H,0),91)<9,"",K$9/2)) and copy across and down.