Hello ^^
i hope you understand my explanations.
I have one sheet. It Shows an overview about contracts.
In the other Sheets there are all the contracts. The sheet are called Contract1, Contract2, Contract3, Contract4 and so on.
The Overviewsheets Looks like this
Contract Number Name
Contract 1 Miller
Contract 2 Smith
Contract 3 Grimm
Contract 4 Dilan
.......
With the help of the following VBA I can jump to the serveral contracts.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
On Error GoTo Ende
Sheets(Target.Value).Select
Cancel = True
Ende:
On Error GoTo 0
End Sub
The Problem is that the Name in the Sheets is missing.
I want to put the Name there.
Is there any funciton like
+ If (sheet 1 is contract, then Name is miller, put it in sheet contract 1 in A1)
I hope you understood my explanations.
greetz Benjamin
Bookmarks