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.
 
I don't know what I did wrong before, but it does indeed work!!!

Thank you!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to format cells on several worksheets 2
Cannot copy worksheet to another file 2
Need to merge worksheets - Excel 2003 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
worksheet renames - specific 0
cells linked from worksheet to worksheet 1
Copy formula from various sheets 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0

Back
Top