software

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: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=518402The names listed in Column A match the associated worksheet names exactly?

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

=HYPERLINK(quot;#quot;amp;quot;'quot;amp;A1amp;quot;'!A1quot;,quot;ClickMequot;)

And drag down.

Brisbane Rob wrote:
gt;
gt; I have a workbook with fifty-one sheets. Fifty of the sheets are labeled
gt; with 50 different customers' names. We cut and paste into the front
gt; sheet every day a two-column range which in column A has the customers'
gt; names and column B has a dollar value. The range is sorted before it is
gt; cut and pasted on column B and the order of the customers' names
gt; changes on a daily basis.
gt;
gt; I want to hyperlink the names in column A to their respective sheets in
gt; the workbook. Is there any way of doing this other than manually?
gt;
gt; Grateful for any ideas. Thanks
gt;
gt; --
gt; Brisbane Rob
gt; ------------------------------------------------------------------------
gt; Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
gt; View this thread: www.excelforum.com/showthread...hreadid=518402

--

Dave Peterson


Thanks, Dave, it works a treat...--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=518402
Dave

What function does the # play in the formula?

Rob--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=518402It'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:
contextures.com/xlfaqApp.html

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

(same page--just further down the page)

Brisbane Rob wrote:
gt;
gt; Dave
gt;
gt; What function does the # play in the formula?
gt;
gt; Rob
gt;
gt; --
gt; Brisbane Rob
gt; ------------------------------------------------------------------------
gt; Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
gt; View this thread: www.excelforum.com/showthread...hreadid=518402

--

Dave Peterson


Once again, thanks.--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=518402