Create a Drop Down from Previous Table Entries in Excel | Everyday Office 064
537 views · Published 19 May 2017 · 4:35 · Indexed 13 October 2026
Channel: Neil Malek · 2017 · Education
Can I create a column that pulls its matching results from another column? To make a drop-down menu that connects one employee to another, use data validation and a table. Then, we can import the finished data set to Visio to create an organization chart. In this tutorial, Neil Malek from Knack Training performs the next step in a data-backed organization chart - creating the perfect spreadsheet of employees. Music: "I Need a Break" by Andrew Applepie http://soundcloud.com/andrewapplepie Knack Training is a software and professional development training company from Orlando, FL. Neil Malek, principal at Knack Training, records software tutorials everyday through the series Everyday Office. Knack Training is recording their entire library to provide lifetime value through KnackCourses.com - soup-to-nuts training in Excel, Outlook, and more. Subscribe to my channel here: https://www.youtube.com/subscription_center?add_user=neilmalek Subscribe to the quarterly tutorial ezine: http://knacktraining.com http://knacktraining.com http://knackcourses.com http://facebook.com/knacktraining http://twitter.com/neilmalek http://instagram.com/neilmalek
