| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Absolute References | Excel Discussion (Misc queries) | |||
| Copying formulas, relative and absolute cell references | Excel Discussion (Misc queries) | |||
| Absolute References | Excel Worksheet Functions | |||
| I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
Hybrid Mode
