Excel "Database"

[MrHydrant1857]

Ok i have asked this question already before but i have gotten no where. I have simple standard cell that i enter a Name, Company, City/State, phone, and email. I would like for that information to be transferred to a table on a different sheet. I then want to use the name cell from the first sheet to select a name I have already typed in based on a drop down or other and then fill out the other cells based on the selection from the name cell. someone please help! I have gone through too many monsters and ibuprofen!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...us-times-entered-post5306826.html#post5306826

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.