A
AJ
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.
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.