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