Separate 1 master list into 2 other worksheets according to key words in excel.

[AND-REE-UHH]

I am looking to make a master list that I can separate into 3 different work sheets according to a certain column containing key words.

Example:

Master list

Andrea 456-456-4568 123 Ave 4 Columbus Ga 12345 Balance Active
Jeanine 789-789-7896 45666 ave A Columbus Ga 45 Balance Inactive

I want to make an "Active" worksheet and an "Inactive" worksheet by using a formula to extract the whole row according to the Active/ inactive status.

Thanks for taking the time to help.

[xladept]

Hi AND-REE-UHH,

Welcome to the Forum!

Are the master records like this?

Data Range

	A	B	C	D	E	F	G
1	Name	Phone	Street	City	State	Zip	Status
2	Andrea	456-456-4568	123 Ave 4	Columbus	Ga	12345	Balance Active
3	Jeanine	789-789-7896	45666 ave A	Columbus	Ga	45	Balance Inactive

[FDibbins]

Hi, welcome to the forum

It would make things a lot easier if you could upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.