Filtering with marcos

[Guest]

I am trying towrite a short bit of code to filter using what a user put in
cell.
ie user puts "01" in cell A3
then the data below is filtered to show only results matching 01.

I know i could use an autofilter but coding would be better for the users.

Any body help!

i am sure this is am easy one for someone

 

[Ron de Bruin]

Hi Dave

Try Advanced Filter
http://www.contextures.com/xladvfilter01.html

Record a macro when you do it manual to get the code

 

[Guest]

Just a thought........if you are writing code for others to use, then YOU use
the version of Excel that is the OLDEST of the users-to-be. Some code
written in some of the newer versions of Excel will not work in some of the
older versions.

.....and note, you can also code in Autofilter to respond to the value in a
specific cell.......

hth
Vaya con Dios,
Chuck, CABGx3