Table of contents

[J Very]

I have a multi page spreadsheet at sheet1. Then created a
table of contents at sheet2. By using a formula (=name!
location) I have the page name in my Table of Contents
from the spreadsheet.

Each spreadsheet page is numbered by using (page set up,
custom footer, &page). How do i get the number into the
Table of Contents?

 

[Guest]

hi,
don't think that will work. &page just numbers the page
starting at 1. so all the pages have 1.
what are you trying to do? create a goto funciton? if so
you might have better luck using cell addresses(upper left
corner) or range names.

 

[sulprobil]

See http://www.mrexcel.com/tip017.shtml

HTH,
sulprobil