Custom Views allows many views to be created and named but only one can
visible at a time.

You must use autofilter or some othe means to create the view you want then
save that view with a name.

Do many times if you have many views.

The Report.xla add-in for older versions was just the ticket for printing
reports using custom views.

Don't know if it is still available for 2007 if that's the Excel version
you're using.


Gord

On Tue, 23 Sep 2008 10:36:17 -0700, coffee gal
wrote:

Gord,

I only used the "year" as an example. This is a complicated sheet and it's
not as easy as just selecting the year. I thought I could use Custom Views
but I can only get one view at a time to work. Is there a trick to get
multiple views using Custom Views? If so, could you please walk me through
it? Thanks so much.

"Gord Dibben" wrote:

Don't put the data on separate sheets. You will regret it later.

Just use Autofilter to select the year to print.

Note: you can always set up different views using ViewCustom Views


Gord Dibben MS Excel MVP

On Tue, 23 Sep 2008 08:58:05 -0700, coffee gal
wrote:

Thanks FloMM2,
But what if the data was all on one sheet, would there be a way to do this?

"FloMM2" wrote:

coffee gal,
In a word, yes.
The easiest way for me is as follows:
Put each year on a separate sheet in the same workbook.
Then label each sheet as a year(i.e., 2008, 2009,...)

If you want to print multiple years, select a worksheet, hold the Ctrl key
and select another worksheet. Then select file, print selected worksheets.
hth
:-)


"coffee gal" wrote:

I have a spreadsheet with info for multiple years. Is there a way to set it
up so that I can print each year independently without having to highlight
that particular section each time I need to print it? Thanks.