A few small questions

  • Thread starter Thread starter vincent
  • Start date Start date
V

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?
..
 
vincent,

1. You cannot insert graphics or cell references in a header or footer.

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

3. "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)." Print Area is definded
by cell ranges not the values in the cell itself.

4. "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?" ""about
reordering data"" if you are talking about the printing changing the sheet,
I have never heard of any printer doing that.


""database like information"" Insert a NAME>define> then click the lower
right corner to slick your cells and hit enter. ie.. =Sheet1!$B$5:$B$18 is
an example. In the Names in the workbook, type database & click Add.

Do a search here for "database" by Gord Dibben. He explains its usage.

Wayne B
 
Back
Top