A pro can do it in a few lines. But for me, at least, the whole point of a forum like this is to help you understand how you can do it yourself. Others may not feel the same way about it.

If you want to, I can teach you how to do that loop; I don't think it's too complicated and I don't think you will either. But I know some people want to learn that kind of thing, and others flee from the prospect in an extremity of boredom. If you're the latter type, let's talk about how to do it with formulae; I'm pretty sure we'll be able to figure out a way, with some thought. If you're the former, I grin and metaphorically roll up my sleeves. Which do you prefer?

Wait, I should have asked something before: Some tasks are better done with VBA because even though it takes longer, you're going to need to do it again and again, so it's worth taking the time up front. For example, you can take fifteen minutes to do a task with worksheet functions—or fifteen milliseconds to do it with VBA, but only after you've taken five hours to write the program. If you need to do it only once a year, the formulae are probably the way to go, unless you decide it's worthwhile to learn VBA anyway. But if you're going to do the task twice a day for the next few years, then the up-front investment is well paid back and VBA is the better choice.

On the other hand, some things are better done with worksheet functions because you need their output not repeatedly but continuously. If you want to enter "Done" somewhere on your worksheet and have the results listed on another sheet not at the end of the day when you run the program but immediately, then formulae begin to look better. Which situation is this?