Thank you! This looks like just what I need....
But because I haven't been doing this for a long time how do I get it to run? I have the code saved in the worksheet and have that saved as a macro enabled excel sheet. I am just not sure of the next step to take.

Thank you for all the help so far.

John