Hello,
I am trying to get this nested loop to work and I keep getting errors.
Can someone please help me fix my code?
I have two sheets with column ranges that I'm comparing text to see if it matches:
Find Stock Symbols
Stock & Symbol Data
For x = 5 To LastRowBofF
For y = 2 To LastRowBofS
If Worksheets("Find Stock Symbols").Range("B" & x).Value = Worksheets("Stock & Symbol Data").Range("B" & y).Value Then
Worksheets("Find Stock Symbols").Range("C" & x).Value = Worksheets("Stock & Symbol Data").Range("A" & y).Value
Else
Next y
End If
y = 2
Next x
Thanks for any help!
Bookmarks