Hi all!

One more question. We are trying to use a repeating formula where one
"arugement" is one specified cell on another worksheet. This arguement
should be the same on ALL repeating formulas. For example, on sheet 1 we
want the number in cell A1 to be the "arguement". On sheet two we want the
formula to be this arguement plus and arguement from sheet 2. ( =Sheet1!A1+A1
) but when we try to drag that formula down, it changes the formula to
+Sheet1!A2 ... A3 ... and so forth. Is there a way to make excel NOT change
that formula (except the end to change)? The Sheet1!A1 needs to stay the
same and the arguement from Sheet2 is what will change.