Extracting multiple records according to a criteria

Morning all,

I have a list of records containing a persons name and information about a contact made with them.

What I want to do is find each occurance of the name and copy all the contact information for each occurance into another worksheet.

Many thanks in advance for any help

Cath

Hi,

Have you checked out the Data Filtering functionality?

With that you can either filter your list in place and then manually copy and paste the filtered records wherever you want, or Advanced Data Filtering will allow you to set up output and criteria ranges and then effectively have the filtering, copying and pasting done all in one hit.

HTH