This is probably pretty simple, but I'm just starting out with VBA, and struggling with how to do this.
I have a few columns, one has dates, one has numbers, and the third I am marking with an "x". It's basically acting as a calendar. The "x" serves to drive a number of other things, such as summing the second column (example below).
It's obviously not hard to manually add that "x", but I feel like there should be an easy way to script a button that looks to the current date (perhaps using "=TODAY()" ), and once you hit that macro button, it will do the work for you. I'm trying to use this as a template for more complex models down the road.
Fro m the data below (I can't post screenshots yet):
Col A is just dates, Col B is y+1 where the first row is a hardcoded 1, Col C is the hardcoded "x", and Col D is IF(Cy="x",SUM($B$3:By),Dy-1).
This is my first post, so please let me know if you need more information.
A B C D
Date # Done? Cumulative
01-01-22 1 x 1
02-01-22 2 x 3
03-01-22 3 x 6
04-01-22 4 x 10
05-01-22 5 x 15
06-01-22 6 x 21
07-01-22 7 x 28
08-01-22 8 x 36
09-01-22 9 x 45
10-01-22 10 x 55
11-01-22 11 x 66
12-01-22 12 x 78
13-01-22 13 x 91
14-01-22 14 x 105
15-01-22 15 x 120
16-01-22 16 x 136
17-01-22 17 x 153
18-01-22 18 x 171
19-01-22 19 x 190
20-01-22 20 x 210
21-01-22 21 x 231
22-01-22 22 x 253
23-01-22 23 x 276
24-01-22 24 x 300
25-01-22 25 x 325
26-01-22 26 x 351
27-01-22 27 x 378
28-01-22 28 x 406
29-01-22 29 x 435
30-01-22 30 x 465
31-01-22 31 x 496
01-02-22 32 x 528
02-02-22 33 x 561
03-02-22 34 x 595
04-02-22 35 595
05-02-22 36 595
06-02-22 37 595
07-02-22 38 595
08-02-22 39 595
Bookmarks