Final Frontier
New Member
- Joined
- Sep 16, 2014
- Messages
- 17
I'm trying to create an if statement in VBA for a large spreadsheet I have. I created a sample of the first few lines in Word to help.
<tbody>
</tbody>
I'm trying to write something that can say if there is a variable in cell E2 down, multiply E2 down by the percentage in column H1. Put the value in M2 down. Repeat for each value in column H. So in this case I would need this process repeated 3 times, first multiplying H1*E2, then E3, E4. Then do the same thing again for H2*E2,E3,E4 etc.
Next I want to copy each value in A2 down in column I2 down for the number of values in column J. So in this case I would need Cells A2-A4 copied and pasted 3 times consecutively.
Thanks!
A | B | C | D | E | F | G | H | I | J | |
1 | item number | account 1 | account 2 | amt | price | jon | 10% | value | ||
2 | 83 | 101 | 202 | 2 | 100 | adam | 60% | |||
3 | 84 | 101 | 202 | 3 | 150 | mike | 30% | |||
4 | 85 | 101 | 202 | 4 | 200 |
<tbody>
</tbody>
I'm trying to write something that can say if there is a variable in cell E2 down, multiply E2 down by the percentage in column H1. Put the value in M2 down. Repeat for each value in column H. So in this case I would need this process repeated 3 times, first multiplying H1*E2, then E3, E4. Then do the same thing again for H2*E2,E3,E4 etc.
Next I want to copy each value in A2 down in column I2 down for the number of values in column J. So in this case I would need Cells A2-A4 copied and pasted 3 times consecutively.
Thanks!