transferring a row of data in a column, please i need help

[doms123]

I am using excel2007 and i have 2 sheets in my workbook

on the first sheet i have the input data sheet

Name ____
b-day ____
age ____
sex ____

and an encode button with the syntax like this...

inputdata = Sheet2.Range("a65536").End(xlUp).Column + 1
Sheet2.Cells(inputdata, 1).Resize(1, 6).Value = Array(Sheet1.Range("C13").Value, _
Sheet1.Range("C15").Value, Sheet1.Range("D15").Value, Sheet1.Range("E15").Value, _
Sheet1.Range("C18").Value, Sheet1.Range("C20").Value)


and on the second sheet is the masterlist like this ....

Name Month Day Year Age Sex
fin February 2 2014 30 female
din February 1 2011 20 female
mig January 4 2012 10 male

and a Edit button and i dont have the code on that button and i want to transfer the data on the the first sheet if i select any column on the masterlist and be transfered on the first sheet. I need the code that can transfer the data if i select any column i selected on the input data sheet.


Please Help me
Thank you in advance..