Hi! Can anybody help me how to extract names from a list in excel?

The Problem:

Let's say the name is in column A, I need to extract all the uniqu
names and make 5 copies each on another sheet.

So in the new sheet, there will now be 5 the same names appearing.

Hope somebody can help me with this. Thanks

--
japorm
-----------------------------------------------------------------------
japorms's Profile: http://www.excelforum.com/member.php...nfo&userid=654
View this thread: http://www.excelforum.com/showthread.php?threadid=46778

I would think that Advanced Filter can do what you want.

The menu is DataFilterAdvanced Filter, and there is a Unique option, and a
target area to copy to.

--
HTH

Bob Phillips

"japorms" wrote in
message ...

Hi! Can anybody help me how to extract names from a list in excel?

The Problem:

Let's say the name is in column A, I need to extract all the unique
names and make 5 copies each on another sheet.

So in the new sheet, there will now be 5 the same names appearing.

Hope somebody can help me with this. Thanks!


--
japorms
------------------------------------------------------------------------
japorms's Profile:
http://www.excelforum.com/member.php...fo&userid=6544
View this thread: http://www.excelforum.com/showthread...hreadid=467780

Yeah, that is possible but...

I need top copy and paste each unique data in 5 cells or rows.

I have thousands of data that needs to be process.

Can anybody help me with that. I think that you'd be using a do loop
syntax here.


--
japorms
------------------------------------------------------------------------
japorms's Profile: http://www.excelforum.com/member.php...fo&userid=6544
View this thread: http://www.excelforum.com/showthread...hreadid=467780