excel - Creating a button which matches 2 columns and put a value in 3rd column -
i want create button should populates data given condition:
suppose have table 3 columns
column1 column2 column3 3 b 4 b 3 4 b 4
the button should show data "b" value in column1 , "4" in column2. also, should put value "yes" in column3, if satisfies above condition.
not sure if want delete values in column 1 , column 2 if not b or 4.
private sub commandbutton1_click() = 2 6 'give range per requirement if cells(i, 1) = "b" , cells(i, 2) = 4 cells(i, 3).value = "yes" end if next end sub
Comments
Post a Comment