Show Rows Button

[Guest]

I have created a calendar of activities and want to create both a
collapsed/summary view (containing just some selected rows) and an expanded
view (containing all rows). I'd like to put a few buttons at the top
("Summary", and "All", let's say) and when I click on one of the buttons,
only display selected rows, based on criteria on content in one or more
columns of a row). Any clues for me how I might do this?

I've searched in help and only found "filters", but I want to filter based
on the content of multiple rows and not have the user have to multi-select to
get the summary view.

Thanks in advance!!!

 

[Dave Peterson]

I like using filters.

I'd use a helper column of cells that contained a formula that would evaluate to
Hide/Show. Then filter on that. (But I don't have any idea what your rules are
or if this is possible for you.)

Another option is to apply Data|Group to your rows.

 

[Guest]

Thanks Dave for responding. I've done a calculated cell and can filter on
that great... it's just that I really don't want to display that column and
the spreadsheet users are so much novices that I would prefer to have a
button that forces the filtering and hiding of some columns. Any idea how to
put filtering in a macro?

I've never written a macro, just done the recording of one.

Steve

 

[Dave Peterson]

Record a couple of macros.

One when you filter to show what you want and one to showall data.

Hide the column and then try running your code.

Thanks Dave for responding. I've done a calculated cell and can filter on
that great... it's just that I really don't want to display that column and
the spreadsheet users are so much novices that I would prefer to have a
button that forces the filtering and hiding of some columns. Any idea how to
put filtering in a macro?

I've never written a macro, just done the recording of one.

Steve