Hi All,

I have a spreadsheet with 2 tabs. first has all contact details for my customers with name, address and so on in a single row. i also have a several columns which tells me the group they belong to with a yes against their row.

I want to be able to use the tab 2 to pull out the customers who belong to specific groups.

for eg: if Mr Smith has a yes against their group RAC, i want him to appear on the second tab of my spreadsheet.

each month the groups will change so instead of copying and pasting i want to use a system where it should automatically update the second tab accordingly.

Vlookup may do the trick but i am not sure how to use this with having so many Yes's?

Your help would be appreciated.

I can use filter but the groups change on a daily basis and i would like to automate this if possible.

I have attached a template with deleting 100s of thousands of customer details.