Thank you JLatham.
Your "However" Instructions were exactly what I needed.--



"JLatham" wrote:

If I am understanding your question correctly, the basic answer is no. A
cell either has a formula or a value in it. If you have formulas in a cell
referencing cells on other sheets (the master) then simply writing a value
into that cell would destroy the formula.

However, you may be able to do this with an IF formula in the cell on the
secondary sheet. Let's assume for the moment that you have a formula there
now something like:
=Master!$A$1+Master!$B$4
and lets assume that when you want another value in that cell instead of the
results of that calculation, you are going to put it into X4 in the master
sheet. You could leave X4 empty or put a zero in it and use a formula like
this in the secondary sheet:
=IF(Master!$X$40,Master!$X$4,Master$A$1+Master!$B $4)
that says: if the value in X4 on the Master sheet is greater than zero, put
the value from X4 on the Master sheet here, otherwise put the results of the
calculation here.

Hope that helps some.

"Muddled" wrote:

In My excel I have multiple tabs in one workbook. On the destination tabs, In
the $$ column a price is sourced from the master sheet tab. Sometimes I want
to substitute a different price than the one computed. Can I make a new cell
on the master sheet overide the destination cell on the secondary tabbed
sheets to show a non computed total without disrupting the existing links
between master & Destination sheets?
--