function to add from a overview sheet information to other sheets

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

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.