Bob,

Thnx...but i have never used vba or macro and not sure how to implement this code........so req u to please help me with a formula to execute