I tried some things and changed two things, I used Ander's file as a starting point (Try-Outs sheet with many extra formulas. Your original table c...
I used your initial formula in G2 and built on it. This this and see if it gives you the expected result. The explanation is in a text box on th...
I thinks that wouldn.t be a problem, what I do jot understand is why the Last payment days are not in ascending order as well as the columns G-K ...
I finaly found the reason, there was an AddIn loaded that itself loaded 2 more. One of these does something that makes Excel 'think' changes have b...
Nothing to do with 365, at least not visibly, I do not use 365 and have 2021 installed and have been using it since it exists. This just started ha...
Hi Mike, Anders, I'm now doubting if there isn't some setting MicroSoft has spontaneously added when closing Excel. I have a file which I haven'...
Hi Lisa, I am very happy my solution worked for you. Your appreciation in words and the fact that you're happy is enough for me
Even it were possible, I don't think it's ethical. If it's not your own file then it might be a breach in an agreement or product you purchased or was...
The moment a calculate ful or whatever is done any formula is updated too or refreshed, this triggers the flag that there has been a change made to th...
Good morning Lisa, Have you been able to test it?
You don't just click, you save attachment to your disk and then open it. This is the macro code in that file below, you will have to either add a b...
Who's file is this?
Play with this one
Just an update, I've not had much time yet but still have it on my ToDo list
Okay, let me play with this, I'll use the image files to vision your file and offer you a possible solution. Just to make sure, the data you enter ...