J
Jim Skrydlak
I've written a very complex application, occupying approximately forty
worksheets. Most of the worksheets have approximately thirty columns; the
number of rows ranges from about fifty to about 1,700. I've written VBA to
archive and restore the inputs. I've also created hundreds of row groupings
and have written VBA to determine whether the detail should be hidden for
those groupings, based on whether the item in question has a non-zero balance
in any year (this is a financial planning application). The users frequently
decide to show detail or not based on subjective judgments, and would like
the ability to save their own groupings and decisions as to whether to hide
or display the detail for each group. Is it possible for me to save this in
a data file (itself an Excel workbook; currently a single-sheet workbook) and
retrieve it?
worksheets. Most of the worksheets have approximately thirty columns; the
number of rows ranges from about fifty to about 1,700. I've written VBA to
archive and restore the inputs. I've also created hundreds of row groupings
and have written VBA to determine whether the detail should be hidden for
those groupings, based on whether the item in question has a non-zero balance
in any year (this is a financial planning application). The users frequently
decide to show detail or not based on subjective judgments, and would like
the ability to save their own groupings and decisions as to whether to hide
or display the detail for each group. Is it possible for me to save this in
a data file (itself an Excel workbook; currently a single-sheet workbook) and
retrieve it?