B
blucajun
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!
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!