Removing/hiding rows that contain/don't contain specific text.

Hi,

Every day I recieve a generated report with contains performance data for everyone who works in our business. Each row starts with the name and login ID of the employee. Is there a way that just rows relating to staff on my own team can be automatically displayed? I have previously created a macro which hid everyone else, but this was based on row numbers and as people regularly get moved to different rows it needed constantly updating, - ideally I need something which can sort the data according to name or login ID.

Many thanks for any help!

Many thanks - will give those tips a try :-)