New to excel , need help!

[null null]

I would like to transfer information from one sheet to another, such as.

If I have sheet 1 with A1 = Chad, B1 = 1, C1 = 2, D1 = 3; sheet 1 with A2 = John, B2 = 4, C2 = 5, D3 = 6

If I type John in A1 on sheet 2, how do I get B1, C1, and D1 to auto populate with 4, 5, and 6

[#2]

Did I answer your question? or you want something else?

[#3]

Thanks for the help Willy Lau