Home

New to excel , need help!

Highlighted
null null
New Contributor

New to excel , need help!

 

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 Replies

Re: New to excel , need help!

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

RE: New to excel , need help!

Thanks for the help Willy Lau