Yes.

You can a hyperlink to the named ranged in the Insert Hyperlink dialog box.
Select the user defined name under the Defined Names section in the Select a
Place in the document list.

Challa Prabhu

"Kellie Anne" wrote:

Hi.
I have an excel workbook with numerous sheets. On sheet 1 i wish to link
the data from the named ranges of the different worksheets.

E.g. Worksheet 2 has data in a named range for one topic, worksheet 3 has
data in a named for another etc, and worksheet 1 is the overview of the other
worksheets.

I want to link them so that if i insert a cell, row, the overview sheet
updates automatically.

Can anybody assist at all?

--
Kellie Anne