Last seen: May 22, 2025
It's a non-breaking space - Chr(160) - which you can replace using the special characters list in advanced options.
Also, you need to use FormulaLocal if you want to use the Italian syntax and function names.
I'd say the best approach is not to give them the workbook with the data in it. Either give them a static summary report, or adopt a completely differ...
What version of Excel / Power Query is it that you are using? The Memo type only applies to the Jet Database structure (Access) as far as I am...
It sounds like you actually want SUMIFS rather than a lookup (which only finds one value).
If you do the unpivot in the sample function that is created, I would think that your process should work since the additional client will just be rep...
If you need to change orientation, you can wrap it in a TRANSPOSE function.
If you want it to start at 1, just remove the -1 at the end and use N11 rather than N11+1
🙂 No worries - just wanted to check I wasn't missing something!
Wouldn't you just use TODAY() rather than DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))?
You could use: ROW(INDIRECT("1:"&N11+1))-1
You seem to have merged two separate saveas codes into one hybrid monster. 🙂 Try just: ActiveWorkbook.SaveAs Filename:= _ "G:My DriveOperatio...
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...