Using Check Boxes to Display Data

[chemnerd1]

Hey all!

First off let me say that I have very little programming experience, which means this is probably gonna be over my head but here we go anyways.

I currently have a spreadsheet that will calculate theoretical values (of molecular ions) for a given peptide sequence you enter. There are about 8 different types of ions that I have it calculate, but usually I only need 2 types. The problem is that there is no need to display all 8 types at one time, but I do need all 8 types to be available at various times. Is there a way to have 8 check boxes relating to the 8 ion types and only have the checked ions shown in the table?

Thanks in advance,

Jeramie

:EDIT:

I just realized there is a Programming forum so if a moderator could transfer this sucker over I would appreciate it (I'm not sure how to delete this thread)

[mrice]

You might try to get your data displayed in a pivot table and then use the Excel functionality to display or hide chosen rows. See the attachment.