Hey everybody, I'm new here and I hope you can help me out with some trivial formula. I have a table where I manually insert data (my daily expenses basically...). As that's a long table, I would like to create a button so that I can directly jump to some cell - I'd be happy if I could have an option for each 1st day of a month. I name the cells accordingly, so the 01.08.2019 is August, the 01.09.2019 is September... and so on. I created a drop down list in H1 with August; September etc. and added a hyperlink function in G1.
Basically I'd like to be able to select a month, say October, from the dropdown list, and click on the hyperlink to go to the respective cell. My current try does not work. Thanks in advance to anybody who can help!
Bookmarks