I truly appreciate your efforts but i have already made a vba macro for that and that's running perfectly. But due to my clients requirement i can not use VBA in this scenario.

Anyways, thanks a ton for your efforts. I appreciate that.