Exel

In Excel, how can I make up a list from a list?
That is, I need a macro that will form a list of names and info taken from an existing list – subject to each name being marked in some way…