Last seen: Jun 12, 2026
Just for information (since Power Query is a better option if you have it), the problem is that you specified the date format for the wrong columns - ...
It would be more helpful if you could attach a sample workbook with the data and the chart?
It would be easier to comment with a sample workbook, but from your description, it sounds like you have added at least one column field. A Value fiel...
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.