Hi

what version are you using ... in ver 2000 there was a (supplied) add-in
called the "report manager" which was designed for just this situation
(tools / add-ins / tick report manager - it then appears on the view menu)

however, to obtain this add-in for ver 2002 / 2003 you need to go to the
microsoft site and download it from there.

Cheers
JulieD

"Abi" wrote in message
...
I selected six sheets from a spreadsheet to print (holding down the CTRL
button to select them).

When they print, they print fine, however the footer prints the same (page
2, page 2, page 2). I need them to print sequentially (page 2, page 3,
page
4...). I've changed the Page Setup to say "start with page 2" because I
need
it to start with page 2. It numbers sequentially when I use "Auto" -
so....
????

Thanks!