Hi there,
I am setting up a code that will automatically filter sheets and create a report and then e-mail it out.
They do this by inputting the report they wish to run in an input box e.g. AR0075 which is linked to a vlookup function. The problem I have is that they won't always remember the number of the report or what it relates to.
So I was wondering if there is anyway of displaying the options available to them i.e. taking them to the sheet to look at before they use the input box.
I tried using a message box to fire up the information but the problem is that the number of reports will constantly be increasing.
Any help is appreciated.
Regards,
Matt
I am setting up a code that will automatically filter sheets and create a report and then e-mail it out.
They do this by inputting the report they wish to run in an input box e.g. AR0075 which is linked to a vlookup function. The problem I have is that they won't always remember the number of the report or what it relates to.
So I was wondering if there is anyway of displaying the options available to them i.e. taking them to the sheet to look at before they use the input box.
I tried using a message box to fire up the information but the problem is that the number of reports will constantly be increasing.
Any help is appreciated.
Regards,
Matt