copy cell difficulties

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

Guest

Example ....
Sheet 1, [cell]A1 = Snoopy

I want "Snoopy" to be copied to Sheet 2, [cell]K7, so if I change "Snoopy"
(on Sheet 1, A1) to "Woodstock", it will change Sheet2,K7 as well.

If I go to Sheet 2,K7 and type "=Sheet1!A1" OR
"=IF(Sheet1!A1="","",Sheet1!A1)"...sometimes it works and sometimes it just
prints the formula in Sheet2,K7.

What am I doing wrong??? Moreover, what am I doing differenlty to make it
work sometimes and not, other times???
 
If it just shows the formula, the chances are that the cell had previously
been formatted as text. Format the cell as general, then enter the formula.
 
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

add hyperlink using sheet names and cells(i,j) 3
Transfering a changing cell value progressively through a workbook 3
Cell Reference 1
Change cell referance based on value 2
Copy non merged to merged cells again 1
Search Entire Sheet instead of 1? 4
Formula for drag and copy 0
Find relevant sheet name 2

Back
Top