I don't know if this is possible:

I have several sheets in a workbook. In Sheet 1 for example I have three set
print areas that should have the numbers 1, 5, 6. The numbers in between are
in other sheet. I don't want to enter manually the number on each page. Is
there a way to set the order for printing and the page number to come up in
the footer? I suppose this will be done with a macro, so I will put a button
assigned to the macro, so that everyone who prints it, uses the button and
the pages come up in the right order.

Any help is appreciated

Thanks a lot
--
Gordana Godzo
Head of Controlling & Budgeting
TITAN Group - Cementarnica "USJE" AD Skopje
Prvomajska bb, 1000 Skopje
Republic of Macedonia
tel: +389 2 2786 138
fax: +389 2 2782 535
e-mail: