Hi guys, I'm still learning and I'm not familiar with using loops which I think would be the solution for this issue.
So I have some code here that I wrote but I'm sure there is a much better way to input this using a loop or array:
If Range("B9").Value = "" Then GoTo Handler
Else...