Last seen: Jun 12, 2026
Compare your formula to Mynda's - they are not the same. 😉
Your first find will either locate the correct column, or fail if the value isn't present. I don't see any code to copy and the rest of the code doesn...
One way would be like this: For village: =MID(B5,10,FIND(",",B5)-11) For city: =TRIM(MID(B5,SEARCH("City",B5)+5,LEN(B5)))
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...