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!