Hi, I use this code to insert values at Column J based on Column B. This code works perfectly fine but I think this is too long. Perhaps there are others ways to simplify my code.
Dim LastRow As Long
Dim z As Long
LastRow = Range("B" & Rows.Count).End(xlUp).Row
For z = 2 To...