Select all the data; use Data | Filter | Auto Filter
Now the dropdown arrows let you make any selection needed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Soapydux" wrote in message
ps.com...
Hi
Trying to do a search facility on a page that has data relating to
areas e.g
Area Name
East Mr Smith
West Mr Jones
East Miss White
West Mr Green
West Mr Blue
What I want to achieve is to select via radial button, the area i.e.
West and then for that to display only the names that relate to West
and so on.
Anybody help?
Thanks