Copy rows from one worksheet to another based on criteria [Closed]


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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!