Forum Discussion
DaneWeatherby
Nov 21, 2023Copper Contributor
Trying to use varible for row
i want to enter amount in cell E1. want to enter row number in E2. E2 can be a row number from 23 to 52 Then add E1 to cell E(E2) and keep running total in E(E2). Thanks for help on best way to do th...
DaneWeatherby
Nov 21, 2023Copper Contributor
DaneWeatherby
Nov 21, 2023Copper Contributor
amount saved to advertising. enter row 24 amount saved to other expenses.
- djclementsNov 21, 2023Silver Contributor
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.
- DaneWeatherbyNov 21, 2023Copper ContributorYes thats what i want to do. I'm not familer with vba.
- DaneWeatherbyNov 21, 2023Copper Contributor