Hi,
i am trying to create an excel presentation form in which you can select 2 (or more) parameters, and the form would allow you to rotate through the available results.
In the attached file, i made a mock up of what i am looking for.
You can select on priority, and on status, and depending on these selections, you should be able to go through all available results by using the spin button.
I have an idea of how to get this to work (by using a helper column to determine if the line is true/false in comparison to the parameter, then copy all the true to another table, and letting the spin button number determine the lookup there), but i was wondering if there would be a simpler solution.
Any help or suggestions would be really appreciated
Thank you
i am trying to create an excel presentation form in which you can select 2 (or more) parameters, and the form would allow you to rotate through the available results.
In the attached file, i made a mock up of what i am looking for.
You can select on priority, and on status, and depending on these selections, you should be able to go through all available results by using the spin button.
I have an idea of how to get this to work (by using a helper column to determine if the line is true/false in comparison to the parameter, then copy all the true to another table, and letting the spin button number determine the lookup there), but i was wondering if there would be a simpler solution.
Any help or suggestions would be really appreciated
Thank you
