Hi, I need some advice on a worksheet i have.
Here is what it is. Example

Name Email Area
J.Doe WASH
J.Doe NY
M.Pesy VA
J.Doe MX

Each of the abov is in each row and column.I have like 800 ppl like
that in the sheet with multipe names attached to diff areas.
Now i want to have a macro that can group all those similar names and
put it under one name like J.Doe and all the areas associated with
it.Is this workable.
I could do it manually,belive me i tried and its a lengthy process.
Advice?


--
crosswire123
------------------------------------------------------------------------
crosswire123's Profile: http://www.excelforum.com/member.php...o&userid=33051
View this thread: http://www.excelforum.com/showthread...hreadid=528665