+ Reply to Thread
Results 1 to 3 of 3

Issue with Cell hyperlink from dropdown list

  1. #1
    Registered User
    Join Date
    09-10-2019
    Location
    Frankfurt
    MS-Off Ver
    2016
    Posts
    2

    Issue with Cell hyperlink from dropdown list

    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!
    Attached Files Attached Files
    Last edited by FabioTel; 09-10-2019 at 02:56 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Issue with Cell hyperlink from dropdown list

    Probably have the formula written incorrectly, should be

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    You were missing an x in the file type

  3. #3
    Registered User
    Join Date
    09-10-2019
    Location
    Frankfurt
    MS-Off Ver
    2016
    Posts
    2

    Re: Issue with Cell hyperlink from dropdown list

    Quote Originally Posted by davesexcel View Post
    Probably have the formula written incorrectly, should be

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    You were missing an x in the file type
    That's exactly what the problem was: actually, the "real" file I was working on has macros, therefore the correct format is xlsm. Didn't think about that. Thanks a lot for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Dropdown List and Vlookup issue
    By aksb in forum Excel General
    Replies: 4
    Last Post: 09-29-2017, 08:34 AM
  2. [SOLVED] Dropdown list minor issue
    By WereElf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2017, 03:23 PM
  3. Replies: 6
    Last Post: 02-02-2016, 04:26 PM
  4. Click on a hyperlink to another sheet and auto filter from dropdown list
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-24-2013, 02:34 AM
  5. Hyperlink sheets dropdown list
    By okelly in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-16-2013, 05:58 AM
  6. Replies: 20
    Last Post: 03-19-2011, 09:13 AM
  7. Replies: 21
    Last Post: 12-02-2009, 03:27 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1