Jaikaram,

It would help if you posted an example. You can easily do this with VBA, but an example is really necessary.

KDB