I have an excel with rows as area and skill levels.Columns contains names.
I need to get a particular area and different skill levels.
I can use auto filter to select the correct area. But then my columns are
not filtered and I get the entire list of names around 200 names. But I need
to display only skill level say 5. Can I use auto filter to filter out the
columns also simultaneously.

Could you upload your sample data* using a free filehost
and post a **link** to it here
*desensitized as appropriate

Eg, you could use this free filehost:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload your sample,
then paste the link into your reply here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"imail" wrote in message
...
I have an excel with rows as area and skill levels.Columns contains names.
I need to get a particular area and different skill levels.
I can use auto filter to select the correct area. But then my columns are
not filtered and I get the entire list of names around 200 names. But I
need
to display only skill level say 5. Can I use auto filter to filter out the
columns also simultaneously.