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


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=518402

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 wrote:

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

--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=518402

--

Dave Peterson

Thanks, Dave, it works a treat...


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=518402

Dave

What function does the # play in the formula?

Rob


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=518402

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 wrote:

Dave

What function does the # play in the formula?

Rob

--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=518402

--

Dave Peterson

Once again, thanks.


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=518402