I am building an inventory workbook. On each row is information related to a part number including count. I wish to add a couple of buttons:
- One that will ADD one to the inventory count
- One that will SUBTRACT one from the inventory count
As a result, there will be two buttons controlling the inventory count on the same row. I would like to be able to duplicate these buttons retaining relative reference in the workbook. For example, the button copied/duplicated to Row 3 will control the inventory count for Row 3.
There will be 100's of rows and changing the control manually is not practical. Ideally, the solution will create 1000 rows with the command buttons created.