Fill Data with formulas with Absolute References
 

How come when you use Fill Data the formulas do not change across the other
worksheets when using Absolute References? All the formulas are the same on
each and every worksheet. I need them to change accordingly.

As an example, I am using $A1 in the formulas, which means I want it to be
$A2 on the next worksheet and so on until it reaches $A60. Can this be done?

Fill Data with formulas with Absolute References
 

How would Excel know that you wanted to increase the row number as you fill
across worksheets?
Are you saying that if you have the formula =$A1 in A20 on sheet1 and you
fill the formula across sheets 2 and 3
that you want the formula in A20 on sheet2 to be =$A2 and in A20 on Sheet3
to be =$A3 ?

Tyro


"heater" wrote in message
...
How come when you use Fill Data the formulas do not change across the
other
worksheets when using Absolute References? All the formulas are the same
on
each and every worksheet. I need them to change accordingly.

As an example, I am using $A1 in the formulas, which means I want it to be
$A2 on the next worksheet and so on until it reaches $A60. Can this be
done?

Fill Data with formulas with Absolute References
 

That is what I'm saying, but I see now, that is impossible.

"Tyro" wrote:

How would Excel know that you wanted to increase the row number as you fill
across worksheets?
Are you saying that if you have the formula =$A1 in A20 on sheet1 and you
fill the formula across sheets 2 and 3
that you want the formula in A20 on sheet2 to be =$A2 and in A20 on Sheet3
to be =$A3 ?

Tyro


"heater" wrote in message
...
How come when you use Fill Data the formulas do not change across the
other
worksheets when using Absolute References? All the formulas are the same
on
each and every worksheet. I need them to change accordingly.

As an example, I am using $A1 in the formulas, which means I want it to be
$A2 on the next worksheet and so on until it reaches $A60. Can this be
done?

Fill Data with formulas with Absolute References
 

Did you see my reply to your other post on incrementing formulas across sheets?


Gord Dibben MS Excel MVP

On Fri, 22 Feb 2008 13:29:00 -0800, heater
wrote:

How come when you use Fill Data the formulas do not change across the other
worksheets when using Absolute References? All the formulas are the same on
each and every worksheet. I need them to change accordingly.

As an example, I am using $A1 in the formulas, which means I want it to be
$A2 on the next worksheet and so on until it reaches $A60. Can this be done?