Hello,
I have tried a few ways and it keeps closing out on me I have 2 columns, J & K which I would like to move the values in column K to empty areas of Column J. There is over 650,000 rows and I don't know how to write this code. I am pasting my code & example of the 2 columns I am working with below:
Sub Trying()
Dim x
Dim Cell As Range
x = 2
Do
Range("J2").Select
If Cells(x, 10).Value = "" Then
Cells(x, 10).Value = Cells(x, 11).Value
x = x + 1
End If
Loop
