Hyperlink auto-population? Please Help

L

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
 
G

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.
 
Top