How can I make a Extras Casting check-in spreadsheet?
I do extras casting for movies and was looking to make a spreadsheet for it. I have a .csv list of information (last name, first name, role, email, etc) and was looking for the spreadsheet to something kinda basic, when i type the last name in the spreadsheet that it will either automatically fill in the other blanks with the rest of the person's info or for it to have a pop-up window that would have all of the names and when i chose the one i want, then it would automatically populate the rest. I am extremely dumb when it comes to Numbers or Excel and I'm not sure how to do it...if anyone has any suggestions of a template to use or how to make one i would GREATLY appreciate it...Thanks
Macbook Pro, Mac OS X (10.7)