| 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? |
| 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 | |||
Threaded Mode
