excel - Create a VBA macro that Find and Copy? -

i need little bit macro of excel.

i need create macro automatically find users , copy values have in other sheet:

i have 1 sheet values contains users , kills , deaths, create 3 sheets more (3 different groups of users), , need macro copy values automatically finding users , copying values.

images describe better:

----(copy values on)----->

you don't need macro this, using worksheetfunction vlookup sufficient.

as example, if have headers in row 1 , users in column a, you'd put cell b2 (the number of kills first user) =vlookup($a2;values!$a$2:$c$9;2;false) , c2 =vlookup($a2;values!$a$2:$c$9;3;false).

the arguments function (which can find in linked document) is:

• first, value you're looking for, in case whatever in a2
• next array of values want return result - vlookup through first column, since want return results other columns include columns a:c in formula.
• what column in range search return result kills column 2, deaths column 3.
• finally whether want have exact match (false) or if approximate 1 ok (true).