Table of contents

J

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?
 
G

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.
 
Top