Hi,
I have a typical data validation list in cell "P3" with about 28names to choose from. I'd like to have two buttons on the spreadsheet next to the drop down list that will allow the user to select the next name (i.e. open the dropdown list and scroll down one name) and the other button that will be called previous (i.e. select the dropdown list and scroll up one name).
Cells P2 and P4 respectively contains:
=INDEX(Sheet1!$G$2:$G$28,IF(MATCH(P3,Sheet1!$G$2:$G$28,0)-1<1,Sheet1!$G$28,MATCH(P3,Sheet1!$G$2:$G$28,0)-1))
=INDEX(Sheet1!$G$2:$G$28,IF(MATCH(P3,Sheet1!$G$2:$G$28,0)>ROW(Sheet1!$G$28)-ROW(Sheet1!$G$2),Sheet1!$G$2,MATCH(P3,Sheet1!$G$2:$G$28,0)+1))
Guidance needed!
Note: I am already using a Macro to print all result cards on one click.
I have a typical data validation list in cell "P3" with about 28names to choose from. I'd like to have two buttons on the spreadsheet next to the drop down list that will allow the user to select the next name (i.e. open the dropdown list and scroll down one name) and the other button that will be called previous (i.e. select the dropdown list and scroll up one name).
Cells P2 and P4 respectively contains:
=INDEX(Sheet1!$G$2:$G$28,IF(MATCH(P3,Sheet1!$G$2:$G$28,0)-1<1,Sheet1!$G$28,MATCH(P3,Sheet1!$G$2:$G$28,0)-1))
=INDEX(Sheet1!$G$2:$G$28,IF(MATCH(P3,Sheet1!$G$2:$G$28,0)>ROW(Sheet1!$G$28)-ROW(Sheet1!$G$2),Sheet1!$G$2,MATCH(P3,Sheet1!$G$2:$G$28,0)+1))
Guidance needed!
Note: I am already using a Macro to print all result cards on one click.
