Template or form with drop down boxes

[drunkchicken]

Hi all, here's my situation. I have to fill out a form (which is simple enough to just retype in excel) for about 120 different students that list their name and the time of their appointment(s). At this point, it looks like I'm going to have to fill out 120 sheets by hand to write their names and appointment times, and I'm trying to see what I could do to make this process easier as it has to be done every school year.

I have the information (name and times) on a spreadsheet. I'm just wondering if there was a form or template or formula to make this process easier. I'm imagining drop down boxes that will either let me search for a name or auto-populate if I type in a few letters. If possible, it would be amazing if the other box with their scheduled times can auto-populate when the student's name is chosen, but the name part is more time consuming and therefore, priority.

I'm just wondering if this is at all possible in excel, and if anyone has done anything similar and wouldn't mind sharing/guiding. Thank you!

[mehmetcik]

Could you not do that with mail merge?

You create a table of names and the appointment times and dates.

Create your Letter in Word

Use the Mail Merge Wizard in word to insert the names, dates, times in the right places.

Then run mail merge to create your 120 letters,

You can print directly of save to your hard drive.