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