coping a formulas to another cell.

[Guest]

I'm working with a complicated spreadsheet. On the recap page one of the
cells is drawing information I input but also from somewhere else. I have
tried coping a cell from one working right, but then the copied cell isn't
drawing any information? How can I copy the cell and formula to correct the
problem? I'm really frustrated and desperate. Any suggestions?

 

[Guest]

try clicking onthe master cell and copying what shows on the formula bar.
(Note hit enter before you leave the cell)
go to the cell you want the new formula in.
click on it and paste into the formula bar.
put any changes you need here.