Forum Discussion

null null's avatar
null null
Copper Contributor
Feb 09, 2018

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

Resources