Hyperlink auto-population? Please Help

[LooseScrew354]

I have (Sheet1) a master list with names, phone numbers, e-mail address, ect.
And Sheet2 with a fax transmittal template. I want to create a (hyperlink?)
button so when I click on the name on Sheet1 it auto populates all the info
in the respective fields onto Sheet2. Formulas? Hyperlink edit? Please help.
Thank you,
John

 

[Gary''s Student]

You can use a worksheet event macro. If you click on a cell in column A, the
event code could copy the items in that row into specific cells in the second
sheet.