Memory

[bnwash]

Hello,

I have a simple spreadsheet with 2 sheets.
Sheet one is used for data input and sheet 2 [linked] provides 7 reports.
At the moment I input the data into sheet 1 and go to sheet to print the reports.
I have set each report up with a page number so when I print I go - Print page 2 etc.
Is there a way I can set up in sheet one formular that that I can print individually the reports instead of doing what I am at the moment.

In otherwords if I want to only print report 2 what would be required in sheet 1

Thanks in advance

Barry

[mudraker]

You would need something like a worksheet change macro.
The macro would run when you change a value in a set cell

example
you set the macro up to print when the value in A1 is updated.
The macro prints sheet 2 page number based on number in A1

If the above suggestion is suitable try the listed macro

To install macro to correct location

Copy this macro
GoTo Excel
Select sheet this is to appy to
Right Click on Sheet Name Tab > select View Code
Past macro into the Worksheet Module displayed

Change red A1 as required
Change Blue Sheet2 as required

Private Sub Worksheet_Change(ByVal Target As Range)
   Dim Rng As Range

   For Each Rng In Target
      If Not Application.Intersect(Rng, Range("a1")) Is Nothing Then
         Application.EnableEvents = False
         Sheets("sheet2").PrintOut From:=Rng.Value, To:=Rng.Value, Copies:=1, Collate:=True
      End If
   Next Rng
   Application.EnableEvents = True
End Sub

[bnwash]

Not sure If I understand what you are suggesting.
Is it posible for me to send the sheets to you

regards

Barry

[mudraker]

If the book is to big to post here post on a site like rapidshare.com then post the link here so that i can download it.

Also make sure you include details of what cell you want to enter the sheet number in to print the report