Copying formula from one sheet to another

  • Thread starter Thread starter Ray Druian
  • Start date Start date
R

Ray Druian

This should be simple, but I keep getting it wrong. In a
single workbook, I have two sheets, "MASTER" and "Diagram."
A cell in "MASTER" has a number in it, say "050009," and I
want to copy it to "Diagram." So I insert in the proper
cell of "Diagram" the formula, "=MASTER!H519." What I want
to display is the content of that cell, not it's formula.
If I change the contents of the cell in "MASTER," I want
the new value to automatically appear in "Diagram," not its
formula. Can someone help?

Thanx,
Ray Druian
 
Hi
check if the cell is NOT formated as 'Text'. change the cell format to
'General' and re-enter this 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

Copy an excel sheet from one file to another including formulas 4
Merge Multiple workbook sheets into one workbook 0
Attempted edit of protected cell jumps user to another cell 2
When using an IF-formula, my diagram treats empty cells as zero 3
Macro to combine worksheets data - overwrites existing 5
HELP - A formula or sheet you want to move or copy contains the name .... 0
How to change the scale in Excel 2007? 1
transfering data from one sheet to another 4

Back
Top