Auto Filter With Auto Complete Ability

GoBow777

Member

Posts: 58

Hello Easter:

Have a look here.

http://www.jegsworks.com/Lessons/num...s/autofill.htm

Matt

Quote:

Originally Posted by Eastar

Merry Chrismas
I have a list From A2:A8 - Sunday,Monday, Tuesday,Wednesday, Thursday,
Friday, Sunday
I create a Col Head on A1 and Use AutoFileter, so everytime, when I click
the arrow on the right side, the list will pop up.
My Question: Is there a way, so that the list can be auto-complete? Say, If
I type M, Monday will come out automatically?

thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I auto refresh a column that has an auto filter in place	Pastal	Excel Discussion (Misc queries)	1	December 18th 07 11:43 AM
Auto Count for Auto Filter Doesn't Function under certain circumst	Jonathan Horvath	Excel Discussion (Misc queries)	2	August 17th 07 03:51 AM
Auto Number the Rows of Auto Filter Result	ashish128	Excel Discussion (Misc queries)	3	April 29th 07 06:41 PM
Auto complete	Excel Novice	Excel Worksheet Functions	1	December 10th 06 07:19 PM
ability to auto file column(s) on a pivot table	km	Excel Worksheet Functions	1	December 20th 04 09:39 PM

All times are GMT +1. The time now is 02:16 PM.

Menu

About Us