I don't understand "all" of what you are trying to do but some
suggestions:
If you want any given number of cells to reference 1 cell as in
reference cell A1, then use the following $A$1 in your formula - and
then when you copy and past the formula - all references will always go
to A1. If you want to always make a reference to 1 row and have the
columns change use A$1. If you want the rows to change but the column
to always stay the same use $A1. The "$" is what "holds" the values to
the specific column and/or row.
If you change a value in your formula "frequently" then make a
reference to a cell in your formula, i.e $A$1. Then if you want a value
to change in mutiple cells - just change cell A1.

If you need to keep a value and make a comparison - enter 1 value in
$A$1 then copy the whole sheet - open a new sheet and do a "PASTE"
"SPECIAL" and select "VALUES" then you will not need the formula.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2306593