I need text info (name and department) to automatically populate a cell in
Sheet 2, when I input the info into Sheet 1. Please tell me there is a way
to do this without writing code.

Thank you in advance.