Thanks Andy, at least it sounds doable. I am not familiar with VBA much. Just started learning it this week. Using macro recorder to help teach myself certain things. I did find a response that you gave to someone else using the Worksheet_Change Event. Could you give me a breakdown in how I should approach this?

http://excel.bigresource.com/Track/excel-zLpTNaWX/