Stan,

As below is sample work book....

AREA CODE
SPPT No. 0130 SHGB No. 72/Kanci Kulon
SPPT No. 0132 SHGB No. 72/Kanci Kulon
SPPT No. 0131 SHGB No. 72/Kanci Kulon
SPPT No. 0153 SHGB No. 75/Kanci Kulon
SPPT No. 0154 SHGB No. 75/Kanci Kulon
etc etc

So, i wish that :

CODE AREA
SHGB No. 72/Kanci Kulon SPTT No. 0130, SPPT No. 0132, SPPT No. 0131
And So on...


Please help








"stanleydgromjr" wrote:


Pran,

Please post your workbook (or sample workbook) - scroll down and see
"Manage Attachments".


Have a great day,
Stan


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115352