Can I search for a worksheet by Tab Name?
Hi,
You could do this. Right click you sheet tab, view code and paste the code
below in.
Type an employee (Sheet name) in a1 and the sheet is selected.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
Sheets(Target.Text).Activate
End If
End Sub
Mike
"Jerry L" wrote:
I am using Excel to track data on my employees. It would be helpful if I
could search of the employee's last name, in stead of scanning the tabs.
Thanks,
Jerry
|