+ Reply to Thread
Results 1 to 5 of 5

From drop down list selection populate multiple Cells

  1. #1
    Registered User
    Join Date
    12-18-2012
    Location
    colorado, usa
    MS-Off Ver
    Excel 2007, 2010
    Posts
    5

    From drop down list selection populate multiple Cells

    From the selection from a drop down list(up to 150 selections) I want to populate Multiple cells based off selection, and data Pulled from another sheet.
    I have some code already written but is hard coded for only one selection.

    see attached sample

    From Sheet 'PLC Info' (the Main Sheet). I want to select a Name through a drop down list at Cell C1.

    I then want to populate(by the name selected),
    Cells C2,C3,C4 and Cells B7:M18 and C32:C35 and B38:M63 and more if necessary,
    Depending on amount of data.

    Data Taken from Sheet 'HEN5SHFT'(This whole sheet from A1:U501 is named as 'HEN5SHFT')

    thanks for the help
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: From drop down list selection populate multiple Cells

    Hi

    Are you going to have a unique sheet (with a defined name the same as the sheet name) for each of the 150 PLC Names? Or are you going to have 150 named ranges on the sheet HEN5SHFT?

    rylo

  3. #3
    Registered User
    Join Date
    12-18-2012
    Location
    colorado, usa
    MS-Off Ver
    Excel 2007, 2010
    Posts
    5

    Re: From drop down list selection populate multiple Cells

    150 unique sheets or could do the other way also.
    Just looking to get a working solution.

    Any ideas are welcomed.
    Last edited by logcabin123; 12-19-2012 at 01:38 PM.

  4. #4
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: From drop down list selection populate multiple Cells

    Hi

    If you are using defined names (either in their own sheet, or on the existing sheet HEN5SHT, then try
    C2: =VLOOKUP($C$1,INDIRECT(C1),2,0)

    If you just want to put the data on its own sheet, with no defined name then try
    C2: =vlookup($C$1,indirect("'" & c1 & "'!A:V"),2,0)

    HTH

    rylo

  5. #5
    Registered User
    Join Date
    12-18-2012
    Location
    colorado, usa
    MS-Off Ver
    Excel 2007, 2010
    Posts
    5

    Re: From drop down list selection populate multiple Cells

    Thank You, Both Work. I didnt realize that you can embed the INDIRECT Statement.
    Thank you for helping out with this.

+ 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