I have a sheet in a workbook that is an array of information

column1 column2 column3 column4
product1 blue round 1
product2 red square 3

On another sheet I have a combobox to list what is in column1, then I have
it linked to another cell. Still on this sheet I have cells that lookup
column1 and pull from the other columns. When the Product is selected I add
1 to column4 on this sheet.

say I pull Product2 then my sheet looks like this:

Product: PRODUCT2 Color: RED Shape: SQUARE number: 4

What I need to do after this is create a button that when clicked will then
change the value in column 4 to 4. This way the next time Product2 is
selected it will be 5.

Is this possible? What code would do that? Thanks in advance for all help.

--
AJ