Last seen: May 22, 2025
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...
Yes, just add that in as another criterion like the first section of the SUMPRODUCT formula.
I think this: ActiveSheet.ExportAsFixedFormat xlTypePFD, FileName should be: ActiveSheet.ExportAsFixedFormat xlTypePDF, NewFile
If they are always in the same order, this would do Pico in E3: =SUMPRODUCT(--($C$12:$C$119=$D3),E$12:E$119,E$120:E$227) I'm not clear on whethe...