help in filtering in excel 2003

[glen2351]

Sorry but i posted this in the chrts section by mistake.

I have a large amount of information in a spreadsheet involving many
suppliers i would like to know how to create a cell where i can type in the
name of the supplier and only that supplier would show. Best thing i know of
to explain more is like the white pages you type in a surnmae and that nmae
appears

 

[Pete_UK]

Have a look at Advanced Filter - Debra Dalgleish shows how here:

http://www.contextures.com/xladvfilter01.html

Hope this helps.

Pete

 

[glen2351]

Thanks Pete, i was looking there but i have now found it now all i have to do
is work how to do it. But is what i wanted thanks Glen