Repeating Formula Question

G

Guest

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.
 
G

Guest

Hi,

use $ to do it

so =(Sheet1!$A$1+A1)

and copy it down

it change the formula between relative and absolute, a $ before Colum fix
the column a $ before row number fix de row when you copy it.

hth
regards from Brazil
Marcelo

"THSaldivar" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to format cells on several worksheets 2
Fill formula down for cells 74 rows apart 3
SUMIF function and cell /sheet reference 3
Excel Copy COUNTIF while retaining reference 7
Continuous Invoice Nos. 3
Cell Referencing 2
HOW TO CREATE A FORMULA TO AUTOMATICALLY INSERT THE DATE 1
vlookup + if formula help! 7

Top