entering text in 2 cells at same time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to enter text in a cell on sheet 1 and have the same text appear in a cell on sheet 2
 
Jack, how about putting a formula in sheet 2 to reference the cell on sheet
1, like this, put in cell on sheet 2 =Sheet1!A1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
jack said:
I need to be able to enter text in a cell on sheet 1 and have the same
Click to expand...
text appear in a cell on sheet 2
 
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

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
using the =page! feature to transpose a row to column 0
Worksheet linking 2
Excel Is this possible?? 3
add hyperlink using sheet names and cells(i,j) 3
Update cell value based on name and specific date 1
difference of 2 cells from 2 sheets to appear on sheet 3? 2
Link text box to a cell 1

Back
Top