Macro that populates a cell on based on the value of another cell

SazzySally · Mar 29th 2016

Hi,

I would like to run a macro that populates each cell in column M based on the value of column H for the same row. E.g. I need the macro to scan each row in column H with IF (OR(h2 = "5254", h2 = "5255"), "Yes","") in m2 then move on to the next cell till the data finishes.

The range of data can vary week on week.

any ideas?

thanks very much

x

JohnCleary · Mar 30th 2016

Re: Macro that populates a cell on based on the value of another cell

Maybe

Code

Sub x()


   Dim c As Excel.Range
   
   For Each c In Range(Range("H2"), Range("H" & Rows.Count).End(xlUp))
      
      If c.Value = 5254 Or c.Value = 5255 Then
         c.Offset(, 5).Value = "Yes"
      End If
   Next
   
End Sub

Display More

Using default references to the range so must go in the worksheet code module

SazzySally · Mar 31st 2016

Re: Macro that populates a cell on based on the value of another cell

thanks so much this worked a treat!

Macro that populates a cell on based on the value of another cell

Participate now!

Share