Hello Toppers,
Thank you for the help.
The macro is working but the column (LOTS) does not get updated.
That is: - With the same name, all the Lot #'s should get displayed
I have shown a small example
Thank you
Nikhil
Bill & Mary Greenspan.......... ...Lots 27, 28, 29 and 30 80,000.0
--
nik_gujarath
-----------------------------------------------------------------------
nik_gujarathi's Profile:
http://www.excelforum.com/member.php...fo&userid=3452
View this thread:
http://www.excelforum.com/showthread.php?threadid=56624