Footers in Excel 2002

[beep]

Hi, I am making a workbook, by importing a worksheet template about a 100 times.

Each worksheet is set to print as 2 pages.

Each of the 2 pages needs to have the same number

There seems to be no way I can automatically assign a page nunber for eack worksheet.

Each new worksheet wants to number itself page 1and 2

Any ideas please!
Mike

 

[plettieri]

Hi:

You could try this technique... a little VBA code...here it is in the header...but easily changed to footer...(shown on the Cpearson site)..

Cell Values In The Header

You can include the value of a cell in the header. For example, the following code will put the value of cell B5 on Sheet2 into the header of the activesheet.

ActiveSheet.PageSetup.LeftHeader = _
Format(Worksheets("Sheet2").Range("B5").Value)

Place formula in B2 or some cell and +1 on each sheet needed to print in your workbook.

hope this helps


plettieri