I'm revising an internal expense report and would like to make it a bit more
automated to force the employee to always fill in the fields and provide all
required info. I have a main summary sheet, mileage form, and
entertainment/meal form. I have the main summary sheet set up with a column
for Category and in each of the cells in this column is a dropdown box that
references a hidden list with specific expense categories as choices (office
supplies, phone, travel, mileage, entertainment/meals, etc.). What I want to
do is hyperlink two of the choices to their applicable form when selected
from the drop down box. In other words, when I choose either "Mileage" or
"Entertainment/Meals" from the drop down box, it automatically jumps to the
"Mileage" form or the "Entertainment/Meals" form. Does the list have to
contain the hyperlinks somehow or is it just not possible?

Also, please keep in mind that I am not familiar with VBA (I searched here
for help first and found some references to VBA but don't understand what
it's all about).

Thanks so much!