Copy rows from one worksheet to another based on criteria

Jsmir - Jun 8, 2016 at 11:18 AM

I have an excel document for our clients based on the type of service they have. I would like to be able to copy and paste the entire row for clients based on their service type from the master list into different sheets named accordingly.

For example:

If row E has the type of client (OF) I want to copy the row (A:L) to sheet 2 labeled Office. If it is a VM client I would like it to be copied to sheet 3 labeled VM Client and MB clients I would like to be copied to sheet 4 labeled MB Clients.