Populate Rows of Data into new spreadsheet based off one cell value

[LaurFe]

I have a Master spreadsheet that consists of customer information (columns A - Q are headers such as First Name, Last Name, Source, Phone Number, etc) and the rows are the customer's information.

In column K, we define which sales associate these customers were assigned to by name (Ted, Jeremiah, Eric, etc).

There are currently 4057 customers in this spreadsheet. This excel book has several other tabs for other data comparisons that all reference this main spreadsheet.

I would like to find a way to create a new excel spreadsheet in a new book that will pull all the customers (all columns of data) that are assigned to "Ted". This way, upon demand, I can send each sales associate their customers in a separate file.

The filtering method takes FOREVER due to the size of the spreadsheet so that has not been a very good solution for me so I am looking for something more automatic.

Thank you!

 

[candybg]

Did you try DATA FILTERS? If not, what did you try that look FOREVER?
A Pivot Table would also be able to give you a list of all customers assigned to a particular sales associate.
My issue with a separate sheet with copied data would be that the copied data wouldn't be updated when your master spreadsheet was updated.