Sorry. . not incredibly versed in Excel lingo, but trying to create a summary
page and when you click on the name it will automatically take you to the
detail worksheet. Can anyone help. . . please??? Thanks :)
--
girlsrope2

I take it that you have a list of sheet names in the Summary sheet. If not,
the following macro will not do it for you. If yes, then it will. I
assumed your list of sheet names are in Column A starting in A2. This is a
sheet event macro and must be placed in the sheet module of the Summary
sheet. The Summary sheet does not have to be named "Summary". To access
that sheet module, right-click on the sheet tab and select View Code. Paste
this macro into that module. "X" out of the module to return to your sheet.
HTH Otto
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rColA As Range
If Target.Count 1 Then Exit Sub
Set rColA = Range("A2", Range("A" & Rows.Count).End(xlUp))
If Not Intersect(Target, rColA) Is Nothing Then
Sheets(Target.Value).Select
End If
End Sub
"girlsrope2" wrote in message
...
Sorry. . not incredibly versed in Excel lingo, but trying to create a
summary
page and when you click on the name it will automatically take you to the
detail worksheet. Can anyone help. . . please??? Thanks :)
--
girlsrope2