Printing different sets of data on same worksheet seperately

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

noscamou@gmail.com - 11 Aug 2006 19:52 GMT

I have a financial model with 12 months of 2006 data and 12 months of
2007 data side-by-side. I would like to print the 2006 data all the way
down the sheet together (and there are several sheets like this) and
then the 2007 data together. With all of the sheets I need to print, it
is a painstaking process to set and reset the print area each time I
want to print.

Does anyone know of a way to automate this process using VB or a macro?
I am not overly experienced in either of those methods.

Thanks in advance.

Reply to this Message

Kernow Girl - 14 Aug 2006 11:42 GMT

Hi Noscamou - using excel 2002 the way I do it is to highlight the first
area I want to print, and set the Print Area, then go to Custom View and
create a new view.
Do the same wiht the second area, ie highlight, clear and then set this as
the print area, create a second Custom View. If you have the Report Manager
Add-In program you can then create a report to print all, some, different
orders, etc of the Custom Views. I have created quite complex 'reports' this
way
Hope this was what you were after ---- Dika

> I have a financial model with 12 months of 2006 data and 12 months of
> 2007 data side-by-side. I would like to print the 2006 data all the way
[quoted text clipped - 7 lines]
>
> Thanks in advance.

Reply to this Message

noscamou@gmail.com - 16 Aug 2006 02:20 GMT

Thanks Dika, this might work. But do you have to do this for each
worksheet? Or can a custom view encompass print areas on different
sheets within a workbook?

> Hi Noscamou - using excel 2002 the way I do it is to highlight the first
> area I want to print, and set the Print Area, then go to Custom View and
[quoted text clipped - 17 lines]
> >
> > Thanks in advance.

Reply to this Message

Kernow Girl - 21 Aug 2006 08:56 GMT

Hi Noscamou - sorry it's taken this long for a response but I only work part
time and have just got it this Mon morning. You may have sorted this out for
yourself already but the custom View would only contain print areas on the
one page (as far as I can work out) , it's the Report Manager Add-in that
allows you to set up a 'report', which is in essence a list of the Views and
their print areas, printing each one after the other. Just go to your addins
and make sure you have the Report Manager.
Hope this clairifies - yours Dika

> Thanks Dika, this might work. But do you have to do this for each
> worksheet? Or can a custom view encompass print areas on different
[quoted text clipped - 21 lines]
> > >
> > > Thanks in advance.

Reply to this Message