Extract list from sheet "A" to sheet "B# based on certain criteria

Hi, I'm new to this forum, and pretty new to Excel too, so please bear with me.. I'll try to explain my problem as good as I can.

1. My workbook has one sheet "LIST" - thats a members' list. It has various columns A-P which has data like "Name" "Email" "Phone" "Company" "Interest" etc...

I'd like to somehow make another sheet "My selection" where I can have another list (autogenerated), say for instance of all those who have "Car" as interest. Or all those who work in company "Abc".

2. Would it be possible to edit the data in "My selection"-sheet - and the input is updated back to "LIST"?

3. Would it be possible to select which columns to extract data from (from "LIST") - so I can select the ones that are most important to be to appear on "My selection"

I'm very thankful for all help and advise.

What you request is possible, but the formulae are fairly complex.

I would suggest you investigate what the built-in data filtering features already in Excel can do for you. In the English versoin, you go to the 'Data' Ribbon and then 'Filter'. Alternatively, you could convert you list to a table, which will automatically apply data filtering.

1) with data filtering, you click on the drop-down for each column and choose how you want to filter the list

2) this request would not be needed if you use data filtering

3) this could be achieved by hiding unwanted columns, but I understand you probably do not want to always be hiding and un-hiding columns, so this is not fully met.

Pauley

Thank you very much for the help, Pauleyb. This was the function I was looking for