Excel File: www.teachexcel...
Excel Forum: www.teachexcel...
Filter lists of data in Excel as you type - this amazing feature works like a search as you type feature in that the data will automatically fill-in as you type.
Here, I'll cover two different ways to achieve this result in Excel. Both ways use macros, but don't worry, I'll cover everything in detail.
First, I'll show you how the features work; then I'll show you how to create the worksheets so that they will support this feature; then I'll show you how to change the macro part of the feature so that it will work with your data; and, lastly, in case you're interested, I go over exactly how the macros work.
Enjoy!)
TeachExcel.com
Негізгі бет Filter Data as you Type in Excel
Пікірлер: 35