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