Last seen: May 22, 2025
If you mean that C38 equals "Top Mount" then you can simply use: =If(C38="Top Mount",(E5*2+G5*2)*2,sumproduct((Lists!$A$1:$A$10=i38)*Lists!$B$...
Just as an alternative formula: =TEXT(B2,"0000-00""-01""")+0 then format as a Date.
Assuming the negative values in your current version should not really be there, you could just use: =IF(MAX(B2-C2,0)-D2/2>0,MAX(B2-C2,0)-D...
I would pass the worksheet as an argument to the email routine: Sub EmailScript(ws As Worksheet) Dim EmailSubject As String, EmailSignature...
If you use AddItem you are limited to 10 columns. The alternatives are to use an array and assign that to the control, or to use a range on a workshee...
I think you'd be better off having a separate table for the values in your named cells.
Did you enable macros when opening the workbook?
Your sales values are text. Select the Sales column, press Ctrl+H to bring up the Find/Replace dialog and then enter $ in the Find box, leave the repl...
Roughly speaking, in PQ you could get the latest date for each Actual value for a given Product/Grade combination, and using that get the latest value...
A Long is a Long Integer, so always a whole number. I suspect you want Double.
If they are selected, you can simply loop: For each ws in activewindow.selectedsheets ws.Range("A:C").EntireColumn.Hidden = True next ws
Your macro works fine for me on 365 but if you're running a non-365 version, remove the @ symbols from the formula.
What exactly are you trying to prevent?
Cross-posted here: Container plan-i want to a program with excel that can do container plan dİrectly, please (excelforum.com)
You could write a separate function for it, or just add a custom column - for example: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Conten...