Hi,
Is it possible to use a combobox on a form, as an autofilter for a worksheet.
I'm using Excel 2000.
For example on the worksheet "myData" I have a series of columns populated with data.
Column 1= User name
Column 2= Status
Column 3= Invoice
Column 4= Paid
On the form I want 3 comboboxes that give the end user the option to filter the data on the worksheet "myData" in columns 1, 2, and 3. The 3 comboboxes refer to the first 3 columns on the worksheet
The thing is I need the comboboxes to not only list all the options in each column, but also to have an option to show all the data (no filter), or all the blanks in that column.
I hope this makes sense.
Thanks in advance for any help.