Populating worksheets info from Dropdown list

[bgreen66]

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.

[dilipandey]

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]

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

Please Login or Register  to view this content.

testflex1.xlsx

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

[bgreen66]

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

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,

[dilipandey]

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>

[bgreen66]

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

[dilipandey]

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



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

[bgreen66]

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.

[dilipandey]

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>

[bgreen66]

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

[dilipandey]

you are welcome bgreen66...


Please mark this thread a [SOLVED].. thx


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