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
|
Similar Threads
