Auto Filter on input box?

[wmtsub]

Currently I am using a column to get the first letter of the adjacent column [company names] and then use the filter drop down box to narrow the viewable results to just that letter.
So in a few keystrokes I can filter to all companies that start with the letter "D". But this entails selecting the drop down box, clearing select all, scrolling to the desired letter and checking it.

So I was wondering if there was a way to create an input box where I could just enter a letter and have it automatically do the rest?
any ideas?

 

[wmtsub]

Hmm, maybe what I shuld have asked is for you to explain the parameters- so I guess that sets the third column?

 

[Fluff]

It is the column number in respect of the first column that has a filter.
So if your data starts in col A then col C will be field 3, but if your data starts in col B then col C will be field 2

 

[wmtsub]

tks

 

[Fluff]

You're welcome

 

[wmtsub]

Don't know why altering this is givng me such issues but I can not seem to figure it out.
I would like to use this on another sheet, it will have two locked rows so i will be looking for answers to poulate from colum "A" row 3 and down.
maybe the third time will be the charm and I will finally understand this.

And thanks for all your patience.

 

[Fluff]

Just change the A1 in the original code to A2

 

[wmtsub]

This works with alpha but does not work with numbers? Can you help?

Sub fltr()
Range("A2").AutoFilter 1, InputBox("Please Enter Site #") & "*"
End Sub​

 

[Fluff]

As far as I know you cannot filter for numbers that start with.

 

[wmtsub]

so this does not work like the regualar auto filter? I can search for #'s with that.

 

[Fluff]

It is a regular autofilter, but you cannot filter on numbers that start with.
Maybe if you explain what you want, rather than posting code that doesn't work, it would help