Lookup name in list

Hey,

I'm really bad in VBA, but I think its fun to try some things.
Got a script now so when someone types in a new range of info, it will be added in the datasheet

This datasheet looks like this:
[number] [name] [surname] [adress] [extrainfo]
[1] [Frans] [Flipkip] [whocares] [ ]
[2] [Tony] [Mafkees] [noidea] [ ]

When I have Flipkip on my first page in a cell (say A1) <-- this cell is always the same
And info in cell A2
Then I want, when I press a button, to return the info from cell A2 into datasheet extrainfo column in row 2

When I have Mafkees on my first page in a cell (say A1)
And info in cell A2
Then I want, when I press a button, to return the info from cell A2 into datasheet extrainfo column in row 3

If someone tells me to upload an example I will have to disappoint him/her. My sheet is so confusing that I can better just try and explain it, so I have 2% chance someone will understand it and is willing to help.

Create a module in your workbook and add the following code:

Please Login or Register  to view this content.

Add a button object to your first worksheet and subsequently link the button to the above routine - change the names of the worksheets in the code provided to meet your requirements