Hi everyone,
First time poster. I've created a spreadsheet for staff to enter their allocated leave dates by placing an 'A' for each day within a particular month (staff in columns and months in rows as attached screenshot).
I'd like to create a left and right button in a cell that will not only state the month in between the buttons (as attached), but also take you to the row of that month.
I'm thinking it would be in the lines of Active X controls then creating a macros but my search has exhausted all avenues for what I'm looking for and appreciate any guidance. Happy to go with a dropdown instead, to choose the month and automatically takes you to that month row if the button option is not possible.
Thanks.
First time poster. I've created a spreadsheet for staff to enter their allocated leave dates by placing an 'A' for each day within a particular month (staff in columns and months in rows as attached screenshot).
I'd like to create a left and right button in a cell that will not only state the month in between the buttons (as attached), but also take you to the row of that month.
I'm thinking it would be in the lines of Active X controls then creating a macros but my search has exhausted all avenues for what I'm looking for and appreciate any guidance. Happy to go with a dropdown instead, to choose the month and automatically takes you to that month row if the button option is not possible.
Thanks.
