Hi Declan,
It’s great, working perfectly. I tested it for other cases too. Your
assumptions are absolutely correct as per my requirements.
I have a huge database, which will be in continuous updation and
additions of the products data. It was consuming hell lot of my time in
maintaining this database.


Once again, Thank you for your time and help.

Declan, I need your email ID. Future in case any help is required I
will contact you.

Regards,

Shiva


--
Shiva
------------------------------------------------------------------------
Shiva's Profile: http://www.excelforum.com/member.php...o&userid=28449
View this thread: http://www.excelforum.com/showthread...hreadid=482576