I’m building a data base of clients and want to use their phone numbers as a trigger to populate a daily schedule on a separate sheet. For example: I type in the clients phone number and want their name and address to populate in their respective cells. I’m sure it can be done just not sure just how to go about it. 
would really appreciate any advice. Cheers. 

​I’m building a data base of clients and want to use their phone numbers as a trigger to populate a daily schedule on a separate sheet. For example: I type in the clients phone number and want their name and address to populate in their respective cells. I’m sure it can be done just not sure just how to go about it. would really appreciate any advice. Cheers.   Read More

​