JayCheezey
New Member
- Joined
- Jul 25, 2014
- Messages
- 17
Hi everyone!
New coder here, I'm just wondering if I could get some help on some simple code.
I'm trying to create a macro that allows me to continuously get the sum of multiple weeks. Each time I run the macro, it adds one additional week. This is the tricky part as I'm not sure what I function I would use to continuously expand a sum formula.
For example, I run the macro, it sums W1 to W2 (=5). The next time I run the macro, it would sum W1 to W3 (=8). And after that sum W1 to W4 (=10)
<tbody>
</tbody>
Thanks a lot in advance. This function is the last part of a large piece of code I'm trying to get done.
Much appreciated!
New coder here, I'm just wondering if I could get some help on some simple code.
I'm trying to create a macro that allows me to continuously get the sum of multiple weeks. Each time I run the macro, it adds one additional week. This is the tricky part as I'm not sure what I function I would use to continuously expand a sum formula.
For example, I run the macro, it sums W1 to W2 (=5). The next time I run the macro, it would sum W1 to W3 (=8). And after that sum W1 to W4 (=10)
A | B | C | D | E | F | G | |
1 | W1 | W2 | W3 | W4 | W5 | W6 | W7 |
2 | 1 | 4 | 3 | 2 | 6 | 4 | 5 |
<tbody>
</tbody>
Thanks a lot in advance. This function is the last part of a large piece of code I'm trying to get done.
Much appreciated!