+ Reply to Thread
Results 1 to 3 of 3

Drop down menu with reference to cell

  1. #1
    Registered User
    Join Date
    09-07-2019
    Location
    Paris
    MS-Off Ver
    365
    Posts
    18

    Drop down menu with reference to cell

    Good morning/evening !


    I would like to create a menu presented as a drop down list so that when I click on any of the choices, it refers to a cell in the same excel sheet. The original sheet I am working with is rather big with about 1000 lines (I cannot break it into smaller sheets because I need all the information inside that one sheet). There are titles for different sections so the menu is really to facilitate the navigation through the sheet. For example, there are 3 sections and I want to go to section 2, I click on the menu, select section 2 and it takes me to the title where section 2 is.

    I have attached a sample of what my big file looks like.

    Hopefully you can help me. I am not very good (if not at all) with vba so any help is very much welcomed.

    Thank you for your time !
    Attached Files Attached Files

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Drop down menu with reference to cell

    Welcome to the forum!

    1. In C2, add a Data > Data Validation > List > Revenues,Operations,Capital
    2. Right click the sheet's tab, View Code, and paste.
    Please Login or Register  to view this content.
    3. Freeze row 3.
    4. Save file as xlsm type.
    5. Test C2 dropdown.

  3. #3
    Registered User
    Join Date
    09-07-2019
    Location
    Paris
    MS-Off Ver
    365
    Posts
    18

    Re: Drop down menu with reference to cell

    Wow, it works ! Thank you, thank you !!

    Hope you have a great day !


+ 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. Drop down menu to reference different sheets in searchable drop down list
    By MJAHNKE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2019, 01:00 PM
  2. Replies: 6
    Last Post: 01-23-2018, 04:49 AM
  3. [SOLVED] Drop down menu that changes the reference sheet.
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-01-2015, 12:47 PM
  4. [SOLVED] Drop down menu that changes the reference sheet.
    By JasonNeedsHelp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2015, 05:04 PM
  5. [SOLVED] Drop Down Menu reference (IF)
    By Stndsh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-01-2012, 02:18 PM
  6. Drop down menu/reference
    By tomdelonge in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2007, 10:35 AM
  7. [SOLVED] Drop down menu-How do you produce a drop down menu in a single cell in Excel
    By Freddo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-04-2006, 04:35 AM

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