Thanks for taking a look at my project, sorry I didn't get back to you sooner but I had to go out of town. Yes I did have a lot of extra code, I was experimenting with some routines and forgot to delete them. Thanks for the tip about the text in the sum column, I forgot about that too.

Yes the worksheet is a work in progress. I don't know how to thank you for your help. You were able to get me going in the right direction. Thanks, I'm trying to learn as I go and you have helped with that too. Thanks again!!