View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RC[_6_] RC[_6_] is offline
external usenet poster
 
Posts: 3
Default Report Manager or Hidden Setup Sheet?

I'm working with a 100+ column spreadsheet that management would like
to see around 50 different reports generated from these columns, with
various sorts, subtotals and totals. I was looking at using Custom
Views and Report Manager to hide/show the columns I need for various
reports, then execute some VBA code to create all the sorts, subtotals
and totals I need.

I thought that another way to do this would be to have a hidden
duplicate 100+ column sheet that is used to setup the data sheet. All
the 50 reports that are needed would be listed here, with option data
in appropriate columns like the Sales Report might have a SRT1 (first
column to sort) in column J, then SRT2 (second column to sort) in
column B, etc. There might be a SBT6 (subtotal this column using
column 6 as the "change" column) in column Z. I think you get the
idea. I haven't worked out all the option coding for this but as
reports are added and removed it seems it would make my job easier by
having this hidden setup sheet. The setup sheet would be read into an
array when the file is loaded and a userform would popup asking what
report the user would like to see using buttons or dropdown box.

I was looking on the web for some example of this but found nothing.
Anyone know of any site that has an example of this? Is there an
easier way to do this? Would using Report Manager be the better way to
go?

Thanks.

RC