Ok. This is an exercise for my understanding of VBA. I am a little iffy on the syntax to paste a value in the next cell when a criteria is met?
BTW, I know I could do this via a VLOOOKUP in VBA, but in this instance I don't want to, this purely to learn the syntax for a situation like this
I am using Find in my code to get the value BTW.
Code:
Dim FVal As Variant 'this is the criteria
If FVal Is Nothing Then
GoTo nxt
Else
Worksheets("Sheet1").Cells( ? ).Offset(0, 1).Value = Worksheets("Sheet1").Cells(2, 1).Value 'where the ? is , that will be the cell with the same value as FVal
End If
Bookmarks