Not possible. A cell can contain either a value or a formula at any one
time. You can overwrite a formula cell by manually entering a value into it
but the formula's gone.

Instead of amending the formulated Sheet2, it may be viable for you to work
further on a static capture of the entire Sheet2 via quick copy n paste
special as values of Sheet2 into a new sheet, making your manual downstream
amendments/adjustments over there. In this way you can retain Sheet2's
formulated functionality as it stands.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"mdj0615" wrote in message
...
Okay, one more question, and I will stop. That worked just great for the
spreadsheet, the Ps on sheet one no longer affect sheet two. I did not
put
into account that I also need to put other numbers onto sheet two
directly,
and I'm afraid to tinker with the formula now. How can I change the
formula
to where it will still be there even if I need to write directly into the
cells. For example, there are times where I need to put a T on sheet 1,
which becomes a 2 on sheet two, but I need to change that value to 4, or
there's a P on sheet one, which puts nothing on sheet two, but I need to
write in a 3.