+ Reply to Thread
Results 1 to 4 of 4

Calling multiple columns/rows from drop down list

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    Denver
    MS-Off Ver
    Excel 2007
    Posts
    25

    Calling multiple columns/rows from drop down list

    I have a drop down list, using data validation, calling from a range name on a different sheet($1). Works great. I see my list of choices.

    What I want to do next is for another named range on another sheet($2) to be called when I select one of the options from the drop down.

    So say the drop down is in I71, when I pick an option from that list it will populate (B72, B73:G73, B74:G74...etc...) from a named range I have already defined on ($2).

    Is this possible? Where would I put the (if I71=Range1, then paste this info into the (B72, B73:G73, B74:G74...etc...) on $1 ?

    Any help with this would be much appreciated.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Calling multiple columns/rows from drop down list

    Perhaps this might help..

    www.contextures.com/xlDataVal02.html
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    06-09-2011
    Location
    Denver
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Calling multiple columns/rows from drop down list

    I have uploaded an example of what I'm trying to accomplish.

    The main sheet is where I want the data from topics to populate to.

    Each red area (topic) is a named range (topic1, topic2, etc.).

    I want to use the dropdown list on the 'main sheet' in G1 to pull one of the ranges I created on the topics page and copy that data into the Green area on the main sheet.

    Im not sure what I should be using or where to put it? A VLOOKUP possibly?
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-09-2011
    Location
    Denver
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Calling multiple columns/rows from drop down list

    Ace,

    The website is good but doesnt seem to fit what I'm looking for...any other suggestions?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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