Question85
New Member
- Joined
- Jun 21, 2018
- Messages
- 1
Hi everyone,
Here is the idea, I have a column of numbers, let's keep it simple and I will adapt later : let's say the column is 2, 4, 6, 8, 10, ... (2 clients added each time) but at a certain point after X lignes (years) I want to take out the ones added X years ago. That means if X is 10, on the 11th ligne the number should be 22 (11*2) - 2 (the first number) and on the 12 th ligne it should be 24 (12*2) - the ones added on 1st and 2nd lignes ... etc... I would like to keep X years a variable. Tried to catch a loop faisable without VBA but I don't see. Any help would be appreciated. Many thanks in advance it s been a while since I used VBA...
Best
Here is the idea, I have a column of numbers, let's keep it simple and I will adapt later : let's say the column is 2, 4, 6, 8, 10, ... (2 clients added each time) but at a certain point after X lignes (years) I want to take out the ones added X years ago. That means if X is 10, on the 11th ligne the number should be 22 (11*2) - 2 (the first number) and on the 12 th ligne it should be 24 (12*2) - the ones added on 1st and 2nd lignes ... etc... I would like to keep X years a variable. Tried to catch a loop faisable without VBA but I don't see. Any help would be appreciated. Many thanks in advance it s been a while since I used VBA...
Best
