Forum Discussion
Trying to use varible for row
DaneWeatherby The first part where you say "add E1 to cell E(E2)" is pretty clear and can be achieved with the INDEX function or the INDIRECT function. For example:
=E1+INDEX(E:E, E2)
-OR-
=E1+INDIRECT("E"&E2)
However, I'm unable to determine what you meant by "and keep running total in E(E2)" in the second part of the request. Perhaps if you shared some sample data or a screenshot with the expected results, someone might be able to assist you further.
- amount saved to advertising. enter row 24 amount saved to other expenses.
DaneWeatherby Sorry, I'm still not sure if I understood you correctly, but it seems like you're saying you want to update/overwrite the actual value of the target cell. Is that right? Do you want to add the value in cell E1 to the current value of the target cell (specified by the row number in cell E2), then "Post" the new amount back to the target cell? If so, you would need to use VBA to achieve this.
- Yes thats what i want to do. I'm not familer with vba.