Repeating Formula Question

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

EXCEL - IF(IFERROR(VLOOKUP question 0
SUMIF function and cell /sheet reference 3
Fill formula down for cells 74 rows apart 3
Excel Copy COUNTIF while retaining reference 7
Code to format cells on several worksheets 2
Continuous Invoice Nos. 3
Cell Referencing 2
Formula Question 2

Back
Top