Can value at A1 toggle hide/show of row 2?
 

Here's a problem that's way beyond my very limited Excel programming
skills. I have a large number (700) of Excel spreadsheets, which
get generated periodically by a Perl script. The structure of
these sheets is always the same; it consists of roughly 10-80 rows
of primary information, each of which is followed by 1-50 rows of
secondary information associated with that primary row. This
secondary information is very useful occasionally, but it is visual
clutter most of the time. The group that uses these spreadsheets
has requested some quick way to toggle the show/hide status of
these secondary rows, without having to laboriously select them,
click on pull-down menus, etc.

This problem is a likely good candidate for a macro-based solution,
but the catch is that macros are out of the question in this case
(at least for the time being) because the Perl script that generates
the spreadsheets cannot write macros into these sheets. (I realize
that the ideal solution would be to generate the sheets in VBA to
begin with instead of Perl, but coding this preferable solution
would take far more time than I have to do this.)

It occurred to me that *if* it were possible for the value in one
cell to control the show/hide status of a row not incident on that
cell, then the task of toggling the visibility of the secondary
rows would boil down to entering a suitable value in such a control
cell, and perhaps have the worksheet perform a global recalculation.

Is it possible for the value in a cell to control the show/hide
status on a row?

Thanks!

kj

--
NOTE: In my address everything before the first period is backwards;
and the last period, and everything after it, should be discarded.

Can value at A1 toggle hide/show of row 2?
 

If you applied an autofilter (data=Filter=Autofilter) to the data and
filtered on the column with the value.

--
Regards,
Tom Ogilvy

"kj" wrote in message
...



Here's a problem that's way beyond my very limited Excel programming
skills. I have a large number (700) of Excel spreadsheets, which
get generated periodically by a Perl script. The structure of
these sheets is always the same; it consists of roughly 10-80 rows
of primary information, each of which is followed by 1-50 rows of
secondary information associated with that primary row. This
secondary information is very useful occasionally, but it is visual
clutter most of the time. The group that uses these spreadsheets
has requested some quick way to toggle the show/hide status of
these secondary rows, without having to laboriously select them,
click on pull-down menus, etc.

This problem is a likely good candidate for a macro-based solution,
but the catch is that macros are out of the question in this case
(at least for the time being) because the Perl script that generates
the spreadsheets cannot write macros into these sheets. (I realize
that the ideal solution would be to generate the sheets in VBA to
begin with instead of Perl, but coding this preferable solution
would take far more time than I have to do this.)

It occurred to me that *if* it were possible for the value in one
cell to control the show/hide status of a row not incident on that
cell, then the task of toggling the visibility of the secondary
rows would boil down to entering a suitable value in such a control
cell, and perhaps have the worksheet perform a global recalculation.

Is it possible for the value in a cell to control the show/hide
status on a row?

Thanks!

kj

--
NOTE: In my address everything before the first period is backwards;
and the last period, and everything after it, should be discarded.

Can value at A1 toggle hide/show of row 2?
 

If you can do this from your Perl script the easiest thing would be to Group
the data then set the outline level. Have a look at Data, Group and Outline,
Group and see if it will work for you.

Robin Hammond
www.enhanceddatasystems.com

"kj" wrote in message
...



Here's a problem that's way beyond my very limited Excel programming
skills. I have a large number (700) of Excel spreadsheets, which
get generated periodically by a Perl script. The structure of
these sheets is always the same; it consists of roughly 10-80 rows
of primary information, each of which is followed by 1-50 rows of
secondary information associated with that primary row. This
secondary information is very useful occasionally, but it is visual
clutter most of the time. The group that uses these spreadsheets
has requested some quick way to toggle the show/hide status of
these secondary rows, without having to laboriously select them,
click on pull-down menus, etc.

This problem is a likely good candidate for a macro-based solution,
but the catch is that macros are out of the question in this case
(at least for the time being) because the Perl script that generates
the spreadsheets cannot write macros into these sheets. (I realize
that the ideal solution would be to generate the sheets in VBA to
begin with instead of Perl, but coding this preferable solution
would take far more time than I have to do this.)

It occurred to me that *if* it were possible for the value in one
cell to control the show/hide status of a row not incident on that
cell, then the task of toggling the visibility of the secondary
rows would boil down to entering a suitable value in such a control
cell, and perhaps have the worksheet perform a global recalculation.

Is it possible for the value in a cell to control the show/hide
status on a row?

Thanks!

kj

--
NOTE: In my address everything before the first period is backwards;
and the last period, and everything after it, should be discarded.