software

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.
Advicegt;?--
crosswire123
------------------------------------------------------------------------
crosswire123's Profile: www.excelforum.com/member.php...oamp;userid=33051
View this thread: www.excelforum.com/showthread...hreadid=528665About 30 seconds to do that with a Pivot table.

Assuming you have a header on each column, Select all your data and do data
/ PivotTable and Pivotchart report, then hit Next / Next / Finish.

Drag Name into ROW fields and then drag Area BETWEEN the ROW field and the
DATA field.

Done.Another option for a nice table of data:-

Drag Name into ROW fields and then drag Area into COLUMN field. Now also
drag Area into DATA field.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

quot;crosswire123quot; gt;
wrote in message
news:crosswire123.25jsyo_1143832206.2725@excelforu m-nospam.com...
gt;
gt; Hi, I need some advice on a worksheet i have.
gt; Here is what it is. Example
gt;
gt; Name Email Area
gt; J.Doe WASH
gt; J.Doe NY
gt; M.Pesy VA
gt; J.Doe MX
gt;
gt; Each of the abov is in each row and column.I have like 800 ppl like
gt; that in the sheet with multipe names attached to diff areas.
gt; Now i want to have a macro that can group all those similar names and
gt; put it under one name like J.Doe and all the areas associated with
gt; it.Is this workable.
gt; I could do it manually,belive me i tried and its a lengthy process.
gt; Advicegt;?
gt;
gt;
gt; --
gt; crosswire123
gt; ------------------------------------------------------------------------
gt; crosswire123's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33051
gt; View this thread: www.excelforum.com/showthread...hreadid=528665
gt;

Thank you.It worked beautifully.
im surprised they didn't teach us this at Univ lol
thanks once again--
crosswire123
------------------------------------------------------------------------
crosswire123's Profile: www.excelforum.com/member.php...oamp;userid=33051
View this thread: www.excelforum.com/showthread...hreadid=528665You're very welcome. The Pivot table is probably the single most powerful
feature that excel has (Yet can be so simple to use), and is certainly worth
getting to grips with.

Regards
Ken..................

quot;crosswire123quot; gt;
wrote in message
news:crosswire123.25jutb_1143834602.9458@excelforu m-nospam.com...
gt;
gt; Thank you.It worked beautifully.
gt; im surprised they didn't teach us this at Univ lol
gt; thanks once again
gt;
gt;
gt; --
gt; crosswire123
gt; ------------------------------------------------------------------------
gt; crosswire123's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33051
gt; View this thread: www.excelforum.com/showthread...hreadid=528665
gt;