Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help :-( - Auto Population | Excel Worksheet Functions | |||
Conditional auto-population, summarize data? | Excel Discussion (Misc queries) | |||
Conditional Auto-Population? | Excel Discussion (Misc queries) | |||
Conditional Auto-Population | Excel Worksheet Functions | |||
Drop-down list & auto-population of cells | Excel Worksheet Functions |