+ Reply to Thread
Results 1 to 11 of 11

Populating worksheets info from Dropdown list

  1. #1
    Registered User
    Join Date
    04-03-2013
    Location
    Bham, AL
    MS-Off Ver
    Excel 2010
    Posts
    9

    Populating worksheets info from Dropdown list

    Hello all,

    New to excel and new to the forum. Looking for help on excel. I have an excel workbook I would like help with. I want to have the users (name 1, name2, name3 etc.) to enter information into their individual worksheet for 4 to 5 different cells. On the master sheet, I want to be able to select a name from the drop down list and information is populated into my master worksheet based on the name selected. I also want to assign a Program leader to to the list that would update back to the name(1,2,3) sheet. Can anyone please help? I have attached my workbook.
    Attached Files Attached Files
    Last edited by JBeaucaire; 04-06-2013 at 04:06 AM. Reason: Corrected Title, as per forum rules. Please take a moment to read the Forum Rules, link is above in the meny bar.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Populating worksheets info from Dropdown list

    Hi bgreen66,

    welcome to the forum.

    I believe you need output in sheet "MasterA" from sheet "master" where all data is getting summarized.. correct ?


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Populating worksheets info from Dropdown list

    If you agree with above post, try using below formula which need to be entered using key combination: ctrl shift enter:-

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    testflex1.xlsx

    Regards,
    DILIPandey
    <click on below * if this helps>

  4. #4
    Registered User
    Join Date
    04-03-2013
    Location
    Bham, AL
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Populating worksheets info from Dropdown list

    Quote Originally Posted by dilipandey View Post
    If you agree with above post, try using below formula which need to be entered using key combination: ctrl shift enter:-

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Attachment 226275

    Regards,
    DILIPandey
    <click on below * if this helps>
    I need the information to pull from the individual name sheets to fill into the Master worksheet. So if name2 is selected on the Master sheet it would populate the information entered on the name2 sheet,

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Populating worksheets info from Dropdown list

    So if name2 is selected on the Master sheet it would populate the information entered on the name2 sheet,
    I would like to know how would you select "name2" on Master Sheet ?


    Regards,
    DILIPandey
    <click on below * if this helps>

  6. #6
    Registered User
    Join Date
    04-03-2013
    Location
    Bham, AL
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Populating worksheets info from Dropdown list

    Name is being selected from a Drop down list (A3). Thanks for your help!

  7. #7
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Populating worksheets info from Dropdown list

    okay... and which sheet has this drop down list (a3) ? Thanks.



    Regards,
    DILIPandey
    <click on below * if this helps>

  8. #8
    Registered User
    Join Date
    04-03-2013
    Location
    Bham, AL
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Populating worksheets info from Dropdown list

    Name1, Name2, Name3, represents the individual users. They will input their information on those worksheets for their workload. The Supervisor will use MasterA worksheet to pull up information for the individual users. On the MasterA worksheet, user will chose a name here from dropdown list (A3) name1,name2, name3. Once a choice is made from the drop down list, we want the chosen name to populate the information from the appropiate name worksheet. I hope that clears it up.

  9. #9
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Populating worksheets info from Dropdown list

    In post 4, you mentioned :-
    So if name2 is selected on the Master sheet it would populate the information entered on the name2 sheet,
    but in above post #8, you clarified that names will be selected on MasterA sheet and this is what I was trying to clarify
    Thanks for this.

    Now, I have updated below workbook to extract data from individual name sheets :-
    testflex1.xlsx


    Regards,
    DILIPandey
    <click on below * if this helps>

  10. #10
    Registered User
    Join Date
    04-03-2013
    Location
    Bham, AL
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Populating worksheets info from Dropdown list

    Yes sir that is correct!!!! Thanks so much!

  11. #11
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Populating worksheets info from Dropdown list

    you are welcome bgreen66...


    Please mark this thread a [SOLVED].. thx


    Regards,
    DILIPandey
    <click on below * if this helps>

+ 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