Hi Venkatesh

I'd recommend a UserForm approach to your issue as it simplifies things significantly. Is this call within your purview?

If not we can look at a Workbook Before Close event and/or a Workbook Before Save Event.

In either case, I'd like to see what your data looks like.