Hello everyone.



I am obviously new. I am pretty good with computer, but have never had to make a form in office before, so i am not sure which program is the best to use. Here is my problem..

At work I typically hand write set up sheets for my team on how to do the job, it contains basic info such as start times, where they start, etc etc. I recently made a basic form in word that I simply fill in the blanks....

but I would like to take it a step forward..... I have about 100 start points and I would like to either automate the start information to be filled in, either by selecting a number from a drop down menu (1=start 1, 2=start 2, etc) once the user selects the number from the start down menu, two other fields will automatically be filled in with the data. If not that way even a prompt or blank field that does the same option, IF Start = 1 THEN Start 1...

I am not sure how to approach this in either Word or Excel (or both or something else.

Can anyone point me in the right direction on what I need to do, or what commands I need to research.

Thanks
Jason