You can use AutoFilter:

1. click on the column A header and:

Data Filter AutoFilter

2. using the pull-down you can display all the rows for any name.
3. copy the visible rows and paste at your destination.
--
Gary''s Student - gsnu200770


"Tony Montana" wrote:

Okay here's my problem. I have a table with a few columns that are in no
particular order. For example:
Column A Column B Column C Column D
Name 1 Date 3 Reason
Name 2 Date 4 Reason
Name 1 Date 2 Reason
Name 4 Date 2 Reason
Name 2 Date 4 Reason
Name 1 Date 5 Reason

What I want to do is extract the data and create a new list for each name on
a different sheet but with no gaps so for example:

Column A Column B Column C Column D
Name 1 Date 3 Reason
Name 1 Date 2 Reason
Name 1 Date 5 Reason

Any help at all would be most appreciated.