Show Rows Button
 

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!!!
--
Steve

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.

sjschmidtky wrote:

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!!!
--
Steve

--

Dave Peterson

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
--
Steve


"Dave Peterson" wrote:

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.

sjschmidtky wrote:

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!!!
--
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.

sjschmidtky wrote:

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
--
Steve

"Dave Peterson" wrote:

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.

sjschmidtky wrote:

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!!!
--
Steve

--

Dave Peterson


--

Dave Peterson