Copying Certain Category from a Mastersheet to another Sheet

I have a master sheet with certain category of staff. Is it possible to copy a certain category from the master sheet to another sheet? Eg if the mastersheet contains "teachers" and "students" and I only want to copy teachers to a new sheet when added to the mastersheet containing students and teachers.


Any help would be appreciated.

Best Answer

Answers