Using a form in Excel to Filter

  • Thread starter Thread starter ccfatzin
  • Start date Start date
C

ccfatzin

I would like to create a form in Excel that is similar to a form in
Access. This form will hold all fields on the underlying spreadsheet
and enable the user to sort using combo box dropdowns. Ideally, the
form would have a button titled RUN that will take all the data the
user selects in the combos and filter the underlying spreadsheet.

Can this be done?? If so....you will save my life!

TIA,
Chris
 
The next version can filter on more columns
I will finish it this winter I hope.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Export Filtered Form Data To Excel 0
Form Combo Box & Pivot table (Excel 2007) 3
Using a Combo Box for Filtering a Continous Form 1
Excel Concatenate Form Name to Parse for function 1
ActiveX Combo Box controls Pivot Table Filter field 3
Refreshing filter on Subform in Access 2010 0
Adding filter to query 1
Dynamic form 3

Back
Top