How Do I....

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

documike - 27 Dec 2004 19:26 GMT

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

Reply to this Message

Debra Dalgleish - 27 Dec 2004 22:09 GMT

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

> 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

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message