How would dynamic ranges work in this particular example?
That's a question with a lot of different, yet all correct, answers. It really depends on the layout of your workbook.

I was thinking it might be best to use the find method but it depends on a couple of factors.

I could write you a macro that will work great for your example but I highly doubt it would work the way you want on your workbook. I wish you the best of luck.