+ Reply to Thread
Results 1 to 5 of 5

Fill a Row based on Drop-Down list selection

  1. #1
    Registered User
    Join Date
    03-28-2012
    Location
    Seattle,WA
    MS-Off Ver
    Mac Excel 2003
    Posts
    6

    Question Fill a Row based on Drop-Down list selection

    Okeys,

    I have a bunch of sheets (assume innumerable), and I have their names in a drop-down list on an index sheet. From there I want to select a sheet name and have it fill out the rest of the row automatically (with values from cells scattered throughout the sheet). Not quite sure where to go from there

    Anywho, thanks in advance!

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,200

    Re: Fill a Row based on Drop-Down list selection

    Hello stamke, Welcome to the forum.

    You can use INDIRECT formula. it would e helpful, if you attach a sample file with desired results. Forum Rule says how to attach a file.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    03-28-2012
    Location
    Seattle,WA
    MS-Off Ver
    Mac Excel 2003
    Posts
    6

    Re: Fill a Row based on Drop-Down list selection

    okay, so what i want is that when i select something from the drop-down, it autofills the row with the data (String Return gives the string apple, banana, or carrot; the other columns give back the number values from top-left to bottom-right of Sheets 1, 2, and 3.
    Anywho, thanks again for helping

    EDIT: The "something" in the drop-down list is the sheet name. Just covering any bases.
    Attached Files Attached Files
    Last edited by stamke; 03-29-2012 at 12:08 AM. Reason: Not Specific Enough...?

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

    Re: Fill a Row based on Drop-Down list selection

    Hi
    Please Login or Register  to view this content.
    Copy across, and update the cell references. Then copy down.

    HTH

    rylo

  5. #5
    Registered User
    Join Date
    03-28-2012
    Location
    Seattle,WA
    MS-Off Ver
    Mac Excel 2003
    Posts
    6

    Re: Fill a Row based on Drop-Down list selection

    Thanks a bundle! Saved me a lot of trouble in the future :P


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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