Repeat Cell Values

[KiloHotel]

Hi Guys,

Silly one that i cannot figure out,

How do I get cell values to repeat down a list of cells based on the value of the cell before?

Example:

Cell F2 has LINK10 and in cell G2 I enter a value TEST for example, I want that to then fill in TEST all the way down the list everytime LINK10 is in the F Column.

Also another thing I'm not too sure about if i change the value say a change in the day halfway down the sheet from TEST to TEST1234 in say cell G25 that it changes only from G25 downwards to TEST1234 against LINK10? Is that possible?

Let me know if i need to explain further

Thanks in advance guys

 

[Learn Excel in Tamil]

Hi
Could you please try with this coding

Sub Test()
Range("F2:F16").Select


For Each cell In Selection
If ActiveCell.Value = Range("F2").Value Then


ActiveCell.Offset(0, 1).Value = Range("G2").Value


End If


ActiveCell.Offset(1, 0).Select


Next