Thank you, learned not only how to use the add in but also text to columns and the xloonup(). PS: You could also use switch() instead of many if() functions. And you also can click special paste values directly without going into the sub menu
Once I have all the employees entered in the table, how can I easily show separate org charts according to department? ie only show sales dept, or finance dept?