filtering

C

create_share

I have a record sheet of different employees from which i
want to keep only one person's entries and delete all
other entries. is there any way to do this. I can't do it
manually because the data i need is in multiple locations
in the worksheet.

thankx!
 
A

Alex Delamain

Use
Data, Filter, Auto Filter
then in the column with the names in choose custom from the drop dow
list
select reason "does not equal" and then the name you want to keep

This will then display only the records that do not match the name yo
want.

Finally delete the unwanted rows and return the filter to (all).
There should now only be the records you wan
 
A

Alex Delamain

What do you mean by multiple locations?

If the data is in a single table then it is easy to use Auto filter. If
the data is spread all over the place then it might be simpler to use
Edit Find to locate references to the person you want to keep and then
extract that data to another sheet.
 
Top