Hi BLRITCHIE;

What you're asking for can be done.

I would use macros to do it. If you want to go this way, I would want to know if you have worked with macros before? Also do you know how to set up range names? If you haven't I would write it differently.

I think it's possible to do it with formulas, but I'm pretty sure it would be harder to set up than macros, and they would be very complicated formulas. I'm not even sure that I could do it, but someone better than me might be able to.