I really need some help. I need to change the existing cell Value in Column 1 where Column 6 meets the required condition.
Example: My table range is (F69:K4323). Column F has a product model name and Column K is a Yes/No. What I would like to do is change the product model name for "Product 1" to "Product 1**********" if Column K = "yes"
I hope it makes sense. Any help would be greatly appreciated.
Thank you very much!
P.S. I was able to find a way to make this work if Column K was actually Column A and Column F was Column B, But cant seem to make it fit my requirements
Dim rngData As Range
Dim lngRow As Long
Set rngData = Range("A1", Cells(Rows.Count, 1).End(xlUp))
For lngRow = 1 To rngData.Rows.Count
If UCase(rngData.Cells(lngRow, 1).Value) = "Yes" Then
rngData.Cells(lngRow, 1).Offset(0, 1).Value = rngData.Cells(lngRow, 1).Offset(0, 1).Value & "************"