kcgundy
03-25-2019, 10:09 AM
I'm setting up something like an inventory spreadsheet. I want to have a 5 "buttons" (rectangle shapes), located in $E$3, E4, E5, E6 and E7.
Clicking each button would add to the total in $G$3 - $G$7, corresponding to the cell the button is in. (e.g. I click the button in $E$4 and the total in cell $G$4 goes from 455 to 456.)
I would like to create a single macro and assign it to all 5 buttons, where the location of the button is recognized (either in name or location) by clicking, and would just add to the total of the adjacent cell, not all 5 adjacent cells. This HAS to be easier than I'm making it but I just can't figure it out. Thanks!
Clicking each button would add to the total in $G$3 - $G$7, corresponding to the cell the button is in. (e.g. I click the button in $E$4 and the total in cell $G$4 goes from 455 to 456.)
I would like to create a single macro and assign it to all 5 buttons, where the location of the button is recognized (either in name or location) by clicking, and would just add to the total of the adjacent cell, not all 5 adjacent cells. This HAS to be easier than I'm making it but I just can't figure it out. Thanks!