Copy rows from one worksheet to another based on criteria

Closed

Jsmir - Jun 8, 2016 at 11:18 AM

Hello,

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.

Copy rows from one worksheet to another based on criteria
Transfer data from one excel worksheet to another automatically - Guide
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Excel vba copy rows to another worksheet based on criteria ✓ - Excel Forum
Activeworkbook.worksheets current worksheet ✓ - Excel Forum
Vba code to move rows to another sheet based on criteria ✓ - Excel Forum

Subscribe To Our Newsletter!