Question and Confused

[susie320]

Hi
I have a spreadsheet of contacts with 3400 people. I want only certain contacts, say just medical facilities. WHen I do the find/replace it brings up 345 which is just what I want. But, how can I capture just those 345 without having to go through them one by one. Can I create a spreadsheet from the find/replace? Thanks
Susie

[Pete_UK]

You can apply a filter to see only those records that you are interested in (e.g. medical), and then you can highlight the visible data and copy it into a new sheet.

Another approach would be to have a drop-down on a second sheet which allows you to select what you are interested in (e.g. medical), and then only the records matching that criteria would be shown on the second sheet (rather like a filter, but the data appears on the second sheet automatically without you having to do anything to the data on the first sheet).

Hope this helps.

Pete