Index page

  • Thread starter Please Help a Dummy
  • Start date
P

Please Help a Dummy

I have an Excel file with 303 pages, and would like to take one cell from
the top of each page to make it into an index.

I created a formula to get the cell contents from the supposed top of each
page number of lines, and then was going to construct a formula to go and
get the cell contents from each one of the supposed cells at the top of the
page. Well, Excel appears not to be very accurate in maintaining the same
number of lines to a page, and you don't end up with the correct cells.
Is there a way of creating an Index of pages taking a cell immediately after
the page break?
I did not think this would be such a difficult issue.

In the PAGE BREAK PREVIEW where it puts the page number on each page, can
you access that page number somehow?

I would like to be able to take this Excel file to a friend who has a full
version of Adobe Acrobat 6.0. Is there any way to take the Excel file and
have hot links so when you click on the Index in Acrobat it will go to that
page without setting it all up manually.
How do you achieve this without doing it manually.
 
F

Frank Kabel

Hi
this is NOT an easy task. It would require VBA and going through each
worksheet and to calculate the pagebreaks.
 
P

Please Help a Dummy

Frank bummer, looks like a full manual job then.

Pity Excel does not make proper accurate page breaks, then it would be a
breeze.

Many thanks.
 
F

Frank Kabel

Hi
you can always enter/insert manual page breaks :)

--
Regards
Frank Kabel
Frankfurt, Germany

Please Help a Dummy said:
Frank bummer, looks like a full manual job then.

Pity Excel does not make proper accurate page breaks, then it would be a
breeze.

Many thanks.
Click to expand...
 
Top