Copy text from one worksheet to another

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

I need text info (name and department) to automatically populate a cell in
Sheet 2, when I input the info into Sheet 1. Please tell me there is a way
to do this without writing code.

Thank you in advance.
 
Select the Cell to be populated in Sheet 2, press =, click the Tab for
Sheet 1, select the Cell where the info is to be entered. Press Enter.
 
It populated the field with this: =Sheet1!C7

Bob I said:
Select the Cell to be populated in Sheet 2, press =, click the Tab for
Sheet 1, select the Cell where the info is to be entered. Press Enter.
Click to expand...
 
Correct, it would appear that you are planning to type your info into
Cell C7 on Sheet 1. Please do so, and observe that the info appears in
that cell on Sheet 2.
 
Back
Top