BradMcLeod
New Member
- Joined
- Jun 8, 2015
- Messages
- 40
I feel this may have to be a macro, because of the scale and the way I'm using it.
I want J3 and higher (J4, J5 etc) to subtract 1 from itself everytime G3 and higher change. In the same line.
If G4 changes, then J4 subtracts 1 from itself
If G5 changes, then J5 subtracts 1 from itself.
Column G will only ever go up. As it is ALREADY in a formula of auto sum of B, C and D. This will have to be a macro, I believe, because the starting number for J will be fluid, and have to be input and periodically changed, manually.
I want J3 and higher (J4, J5 etc) to subtract 1 from itself everytime G3 and higher change. In the same line.
If G4 changes, then J4 subtracts 1 from itself
If G5 changes, then J5 subtracts 1 from itself.
Column G will only ever go up. As it is ALREADY in a formula of auto sum of B, C and D. This will have to be a macro, I believe, because the starting number for J will be fluid, and have to be input and periodically changed, manually.