Hi ExcelledSoftware, I haven't followed the entire logic of your response; however, I would like to see the VBA route just for the fun of it (if it's not too much trouble). I've taken a VBA course years ago and want to see if anything would make sense to me. My job requires increased mastery of Excel so I'll be asking lots of questions as the days go on. Thanks