Auto hyperlinking

[Brisbane Rob]

I have a workbook with fifty-one sheets. Fifty of the sheets are labeled
with 50 different customers' names. We cut and paste into the front
sheet every day a two-column range which in column A has the customers'
names and column B has a dollar value. The range is sorted before it is
cut and pasted on column B and the order of the customers' names
changes on a daily basis.

I want to hyperlink the names in column A to their respective sheets in
the workbook. Is there any way of doing this other than manually?

Grateful for any ideas. Thanks

 

[Dave Peterson]

The names listed in Column A match the associated worksheet names exactly?

if Yes, you could put this formula in column C:

=HYPERLINK("#"&"'"&A1&"'!A1","ClickMe")

And drag down.

 

[Brisbane Rob]

Thanks, Dave, it works a treat...

 

[Brisbane Rob]

Dave

What function does the # play in the formula?

Ro

 

[Dave Peterson]

It's one of the HTML thingies. It's used for the Subaddress of a hyperlink.

You'll see them in links (usually at the top of the page) that point further
down the page:

For instance, on Debra Dalgleish's site:
http://contextures.com/xlfaqApp.html

If you let your cursor linger over those links at the top, you'll see:
http://contextures.com/xlfaqApp.html#App01
and
http://contextures.com/xlfaqApp.html#AtStartup

(same page--just further down the page)

 

[Brisbane Rob]

Once again, thanks.