Im getting an error that my next is without a for :/ What am I missing here. I want it to check column C (cells(y,3)) and if its blank, then look at column A, find the matching value in G and then give the corresponding value in F in column C. And if it's not blank, then move onto the next cell vertically.
Dim x As Double
Dim y As Double
For y = 2 To 84212
For x = 531 To 632
If IsEmpty(Cells(y, 3)) Then
If Cells(y, 1).Value = Cells(x, 6).Value Then Cells(y, 3).Value = Cells(x,7).Value
Else: Next x
Else: Next y
End Sub
Aucun commentaire:
Enregistrer un commentaire