+ Reply to Thread
Results 1 to 1 of 1

Display Column in Sheet Based on Drop-Down List Selection

  1. #1
    Registered User
    Join Date
    10-14-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    47

    Display Column in Sheet Based on Drop-Down List Selection

    I have a master sheet of data, tab named [Master]. This sheet contains many columns, so it takes a while to scroll to find a specific column range and is clumsy to do so. I have created a drop-down list using Data>Data Validation>List in cell $A:$A. Each drop-down selection is named after the field name of the intended column the user wants to navigate to; for samples sake, let's assume the drop-down options are $G:$G, $S:$S, $AA:$AA, $G$G, etc... If the user selects "$AA:$AA" from the drop-down options in cell $A:$A, the screen would automatically navigate to column $AA:$AA in a flash so the user can edit whichever cell in that range is intended for.

    In essence, I don't want my end users to have to manually scroll to the right to find the column they want to view, I want them to automatically see it based on a drop-down list selection. Other methods are valuable to my ears and mind

    Please help.
    Last edited by huntethic; 04-14-2015 at 01:23 PM.

+ 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. Populate column based on drop down list selection
    By leteezer in forum Excel General
    Replies: 2
    Last Post: 01-29-2015, 01:16 PM
  2. [SOLVED] Grab Data from more than one column Based on Selection from List in a different sheet
    By Chantal4130 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-04-2014, 10:22 AM
  3. Populate Drop-down list based on selection from previous drop-down list
    By poison_stone in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-11-2012, 06:10 PM
  4. Replies: 1
    Last Post: 08-15-2012, 12:13 PM
  5. Multiple results to display based on selection made from drop down list
    By scoot_eruk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2012, 05:03 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