Have 1 cell populate another
I have SHEET A and SHEET B; on each, there is a column LAST_NAME.
Is there any way to have SHEET B be populated when SHEET A is filled in?
In other words, if someone enters "SMITH" in the LAST_NAME column of SHEET A, I would love to see it automatically populate the LAST_NAME cell in SHEET B.
Please advise and thanks in advance!
Help Article Resources
Check out the Formula Handbook template!