Thanks for your valuable advice. I will try to implement your suggestion but can you please elaborate your following suggestion:-

"Writing values to the sheet will have this procedure calling itself over and over.
Look into disabling and re-enabling Events to prevent this."

I will definitely take care for the suggestions related to cross posting in future.