Table of contents from Named ranges?

[NealUK]

Just a quickie.
Is it possible to construct a table of contents from named ranges?
I have a spreadsheet with suppliers names and then their products. As i get
new suppliers, they get inserted into the list. This list now stands at 124
pages long.

Obviously when i insert a new supplier, the list becomes incorrect.
I know that i can do this sort of thing with Word, but it doesn't seem to
import into Word at all well.

I have named the cell with the suppliers name, so that i have 43 named
areas.
I need to construct a simple table of contents with

suppliers name..........page 43
next supplier..............page 67

If anyone has any ideas about how to go about this i would be very grateful

many thanks
Neal

 

[Bruce Cooley]

Neal,

Maybe you could paste the list of range names and make each one into a
hyperlink that goes to the first instance of that supplier in your list?

Bruce Cooley


: Just a quickie.
: Is it possible to construct a table of contents from named ranges?
: I have a spreadsheet with suppliers names and then their products. As i
get
: new suppliers, they get inserted into the list. This list now stands at
124
: pages long.
:
: Obviously when i insert a new supplier, the list becomes incorrect.
: I know that i can do this sort of thing with Word, but it doesn't seem to
: import into Word at all well.
:
: I have named the cell with the suppliers name, so that i have 43 named
: areas.
: I need to construct a simple table of contents with
:
: suppliers name..........page 43
: next supplier..............page 67
:
: If anyone has any ideas about how to go about this i would be very
grateful
:
: many thanks
: Neal