Hello,
First of all, i will thank all who reads this question.

And such a good forum.
I have a question regarding a Macro in Excel 2007.

Basically i have spreadsheet which is a small database.

Sheet1 is a database. Sheet1 keeps all data
Sheet2 is a inputsheet or form.

What i need is, that when input is done, than it will search in Database and match it, copy the values to database.

Sheet2:
C E F
Name Input Age Input weight
16 John

Ex. i am going to fill age and weight in E16 and F16.

So what i want a macro in input sheet. And macro has to copy from E16 & F16, than search for "John" in sheet1 and transfer data to sheet1 when it can mach "John" in sheet1. All names are placed in Column H in sheet1.

John is placed in Column H with names on Sheet1 on row 23. So the data from input has to be copied to sheet1 at C23&G23.

And it will be delightfull with a standard error message, when or if John is not listed in database or sheet1. And maybe with a msg that "copy succesful" if a match.

I hope you can help me. I will be happy. Atttaching file too....