A few small questions

[Vincent]

I have an Excel document with many tab (actually it look
like a database, before any other thing no I can't move
it to Access (corporate reasons).

I also have a restriction to avoid using macro!!!!

First is there a way for footer or header information to
include info from cells in the speadsheet.

Second you can define info to repeate at the top, what
about at the bottom of the page.

Third the sheet that serve for report can have up to 8
pages, can the printing zone be define by a cell value,
so that page x of y (the y part be other than 8).

I have the database part in a sheet but you need be
carefull about reordering data because of the numbering,
is there an other way to have database like information?

 

[David McRitchie]

As much as I hate inline comments here are
my inline comments.

I have an Excel document with many tab (actually it look
like a database, before any other thing no I can't move
it to Access (corporate reasons).

I also have a restriction to avoid using macro!!!!

** That could could be a problem for you **

First is there a way for footer or header information to
include info from cells in the speadsheet.

** Not without a macro **

Second you can define info to repeate at the top, what
about at the bottom of the page.

** Not provided for in Excel

Third the sheet that serve for report can have up to 8
pages, can the printing zone be define by a cell value,
so that page x of y (the y part be other than 8).

** Prior to Excel 2000, You could add numbers to page
** &[Page]+1 of &[Pages]+1

** With Excel 2000 the above no longer works, instead use
Page Setup, Page tab, first page number: change the word Auto
to the number for your first page. But when I try this in my Excel 2000
by placing a 2 into that box, I get the following in Print Preview
a first page that indicates page 3 of 8 and at the end Page 8 of 6

I have the database part in a sheet but you need be
carefull about reordering data because of the numbering,
is there an other way to have database like information?

** I think you will have to provide more information about
what you have and what you really want instead.