I have a macro set up in Excel which takes some pasted data and parses it out into a new sheet. From there, I'd like it to read if a value exists In any cell in column K, and if so, places a value on my first sheet into the same row but in column Q.
A bit confusing, I'm sorry. I've tried
If Range("K:K") <> "" Then
Range("Q:Q") = ("Input!R2C2")
End If
But like it reads, it fills data for the entirety of column Q. I want it only to fill in data where a value exists in column K.
Aucun commentaire:
Enregistrer un commentaire