Workbook Containing Contact Sheet that populates data when name is recognized in sheet.

%3CLINGO-SUB%20id%3D%22lingo-sub-3353958%22%20slang%3D%22en-US%22%3EWorkbook%20Containing%20Contact%20Sheet%20that%20populates%20data%20when%20name%20is%20recognized%20in%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3353958%22%20slang%3D%22en-US%22%3E%3CP%3EEssentially%20I%20have%20a%20list%20of%20clients%20and%20partners%20that%20I%20want%20to%20input%20into%20a%20contact%20sheet%2C%20then%20when%20I%20type%20their%20name%20(if%20a%20client)%20or%20a%20name%20and%2For%20abbreviated%20code%20contained%20on%20the%20contact%20sheet%20for%20partners%20(If%20a%20partner)%20then%20I%20want%20their%20Email%20and%20phone%20number%20to%20populate%20as%20well%20it%20hyper%20link%20the%20people%20included%20on%20the%20transaction%20so%20if%20I%20click%20the%20text%20in%20the%20cell%20it%20will%20start%20an%20email%20with%20everyone%20cc'd.%20Finally%20if%20possible%20I%20would%20like%20it%20to%20this%20like%20this%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInput%20contact%20details%20into%20contact%20sheet%2C%20then%20put%20first%20name%20in%20B2%2C%20last%20name%20in%20C2%2C%20Phone%20%23%20populates%20to%20D2%2C%20and%20Email%20to%20E2.%20Then%20in%20H2%20I%20want%20to%20put%20in%20a%20full%20name%20and%20have%20it%20put%20the%20persons%20%23%20in%20I2.%20I%20want%20to%20do%20the%20same%20in%20K2%2C%20M2%2C%20and%20P2%20then%20I%20want%20it%20to%20take%20the%20email%20of%20everyone%20involved%20and%20link%20it%20to%20the%20%22Send%22%20text%20in%20cell%20R2%20so%20I%20can%20click%20it%20and%20have%20it%20open%20an%20email%20to%20all%20parties.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20this%20may%20be%20super%20complex%20and%20I'm%20not%20sure%20if%20its%20possible%20but%20creative%20ideas%2C%20solutions%2C%20or%20alternatives%20that%20favor%20efficiency%20and%20automation%20would%20be%20nice.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3353958%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

Essentially I have a list of clients and partners that I want to input into a contact sheet, then when I type their name (if a client) or a name and/or abbreviated code contained on the contact sheet for partners (If a partner) then I want their Email and phone number to populate as well it hyper link the people included on the transaction so if I click the text in the cell it will start an email with everyone cc'd. Finally if possible I would like it to this like this;

 

Input contact details into contact sheet, then put first name in B2, last name in C2, Phone # populates to D2, and Email to E2. Then in H2 I want to put in a full name and have it put the persons # in I2. I want to do the same in K2, M2, and P2 then I want it to take the email of everyone involved and link it to the "Send" text in cell R2 so I can click it and have it open an email to all parties.

 

I know this may be super complex and I'm not sure if its possible but creative ideas, solutions, or alternatives that favor efficiency and automation would be nice. 

0 Replies