Hyperlink auto-population? Please Help
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 |
Hyperlink auto-population? Please Help
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. -- Gary''s Student - gsnu200749 "LooseScrew354" wrote: 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 |
All times are GMT +1. The time now is 02:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com