Thread: Rosters/Sorting
View Single Post
  #4   Report Post  
Mazzaropi Mazzaropi is offline
Senior Member
 
Location: Belo Horizonte, Brazil
Posts: 170
Lightbulb

Quote:
Originally Posted by Alt255 View Post
Company puts out a training roster every week.

It has 800-4000 names on it.

I only care about the information for the people in my direct section.

Easiest way for me to remove the people i dont care about and only keep the 35 names and infomation i do need.

Like if names = (MYLIST) display them, if not then hide/remove them
-------------------------------------------------------------------------

Dear Alt255, Good Afternoon.

Without seeing the worksheet is difficult to suggest any effective thing but if you have one common field you can use the Auto- Filter.

"...I only care about the information for the people in my direct section..."
If these people have a department code or your name at any column of data as boss or other thing like this use Atuo-Filter.

Is it possible?
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil