I have an excel worksheet with over 50 sheets, each sheet contains a lot
number in cell B7 which is also the name of the sheet. Is there a way to
make the first sheet where you type in lot #G0116 for example and the user is
"hyperlinked" to that sheet?

Any help wuld be appreciated~

How about listing all the lot numbers in the first sheet - leave a cell
blank, and next to it put in the lot numbers in columns - col A blank, Col B
contains 25 lot numbers, Col C blank, Col D contains last 25 lot numbers.
Click on Col A1, right click and select Hyperlink. On the left side, select
"place in this document" and select the tab that refers to the lot number.
Of course - you would want to generate all the sheets and name them before
you do the hyperlink.

HTH-

Carole O

"Susan" wrote:

I have an excel worksheet with over 50 sheets, each sheet contains a lot
number in cell B7 which is also the name of the sheet. Is there a way to
make the first sheet where you type in lot #G0116 for example and the user is
"hyperlinked" to that sheet?

Any help wuld be appreciated~

I wish that would work, but someone else is creating new lot numbers every
week, and they have no idea how to set up a hyperlink, i was trying something
simple

"Carole O" wrote:

How about listing all the lot numbers in the first sheet - leave a cell
blank, and next to it put in the lot numbers in columns - col A blank, Col B
contains 25 lot numbers, Col C blank, Col D contains last 25 lot numbers.
Click on Col A1, right click and select Hyperlink. On the left side, select
"place in this document" and select the tab that refers to the lot number.
Of course - you would want to generate all the sheets and name them before
you do the hyperlink.

HTH-

Carole O

"Susan" wrote:

I have an excel worksheet with over 50 sheets, each sheet contains a lot
number in cell B7 which is also the name of the sheet. Is there a way to
make the first sheet where you type in lot #G0116 for example and the user is
"hyperlinked" to that sheet?

Any help wuld be appreciated~

You can do it with a macro. If you are interested in trying it it works by
responding to changes in Cell A1. When the value is changed the macro tryes
to send you to the sheet specified in the A1. To make it work right click on
the sheet and select view code. Paste this in the code window...

Private Sub Worksheet_Change(ByVal Target As Range)
Dim wks As Worksheet

If Target.Address = "$A$1" Then
On Error Resume Next
Set wks = Sheets(Target.Value)
On Error GoTo 0
If wks Is Nothing Then
MsgBox "Sheet " & Target.Value & " does not exist."
Else
wks.Select
End If
End If
End Sub
--
HTH...

Jim Thomlinson


"Susan" wrote:

I have an excel worksheet with over 50 sheets, each sheet contains a lot
number in cell B7 which is also the name of the sheet. Is there a way to
make the first sheet where you type in lot #G0116 for example and the user is
"hyperlinked" to that sheet?

Any help wuld be appreciated~