Last seen: Jun 11, 2026
Yes, that is the issue. I assume you have done exactly that in the sample workbook because now you have a mix of actual numbers and numbers stored as ...
There's no file attached but, in the meantime, if your codes are stored as text in the worksheet, then that code won't find them because it converts a...
You could do it with power query if you have it, as in the attached version of your workbook. If you have 365 (or 2021 I think) you could use FILTE...
I'm not really sure I followed the logic fully, but is this anything like what you wanted?
This should work on 64bit.
It sounds like you just need to protect the VBA project in the VB Editor.
Can you not just remove everything apart from the last 3 columns, then pivot on description as Mynda suggested before? That appears to do what you wan...
Yes, you could add a helper column using DATEVALUE and creating a date string that your regional settings can work with - for example (zB): =D...
hWnd should also be LongPtr in that code as it's a handle.
I don't get any prompts with your code. You don't need two SaveAs lines though. The second one can just be: wbkNew.Save since you already saved...
The FILTER function will return headers (they are just data as far as it's concerned) but only if they are part of the data range you specify and if t...
I think Catalin's point is that you can do something like: =CUBEVALUE("ThisWorkbookDataModel",$B$5,$C8,D$6,"[Data].[Date (Year)].&["&D...
Just for info, you could also use something like: =COUNTIF(B54:J54,"?*") to only count cells with at least one character in them.
For a formula version, in C2: =IFERROR(INDEX($G$1:$Y$1,AGGREGATE(15,6,1/($G2:$Y2>0)*(COLUMN($G2:$Y2)-COLUMN($G2)+1),COLUMNS($A$1:A$1))),"") a...