Change the value of a cell

D

dayton

I need a formula that changes the value of one cell based on the value of
another.

If my value in A2 equals DS I want to change the value of cell M2 to match
the value of B2.
Else do not change any values.

T.I.A.

Dayton
 
S

steve

Dim cell as Range
Set cell = ???? ' Activecell, or Range("C2"), or ???
If Range("A2") = "DS" then
cell = Range("B2")
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Word macro that can call cells out of Excel for a find and replace 0
Newbie Help - IF Yes No Function 0
Drop down list control value in vba 2
Would like to input 3 letters into a cell, each having a different numerical value 5
Conditional format if difference in cell values greater than 0.50% 1
Arrays and scattered cell values or another way? 16
Need to Capture the initial value of a cell. 1

Top