Fill Data with formulas with Absolute References

H

heater

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?
 
T

Tyro

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
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 

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

Fill Data across multiple Worksheets - Formulas 1
Way to keep formulas unchanged when deleting rows? 9
Copying formulas, relative and absolute cell references 3
Convert selected formula references from relative to absolute 6
Copying a range of data without adjusting formulas 16
Applying Named Ranges to Existing Formulas 3
Import data, fill adjacent formulas 1
External Data and Formulas 1

Top