How to check one cell value to diffrent cell

A

Adarsh Nath

How to check one cell value to diffrent cell and check the condition and if
fulfils the condition than return a value from a different cell to the cell
we Started comparing
 
D

Dave Peterson

dim Cell1 as range
dim Cell2 as range
dim cell3 as range

set cell1 = somecellinyourcode1
set cell2 = somecellinyourcode2
set cell3 = somecellinyourcode3

if cell1.value = cell2.value then
cell1.value = cell3.value
end if
 
Top