How Do I....

  • Thread starter Thread starter documike
  • Start date Start date
D

documike

I want the end user to select items from a table (such as a row) using a
list box, check box, or whatever works best, and only have those selections
put into another sheet in a workbook. I've run into a problem where if I
use multiple list boxes or check boxes, they all interact with each other
instead of independently... Maybe I'm taking the wrong approach to the
problem...Any ideas? Thanks
 
Instead of check boxes, you could have the user mark the row by typing
an X. Then, use an Advanced Filter to extract the data to another sheet.
You could create a macro to run the filter, and a macro to clear the
marks after filtering.

There are instructions for Advanced Filters in Excel's help, and here:

http://www.contextures.com/xladvfilter01.html
 
Back
Top