| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative reference won't update
Hello,
I've got a row of about 8 formulas and contain and absolute and a relative reference in it to another worksheet. My problem is this: A1 contains =INDIRECT("Database!$F2") and the rest of the column is similiar. I would like for the formula in A2 to increase to $F3 automatically as i drag the formula's down, and continue for about 100 columns. This isn't happening. I get the exact same formula all the way down. Can anyone give me a hand please. Thanks BOB Reynolds |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative Reference help | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| relative reference | Excel Discussion (Misc queries) | |||
| Relative Reference | Excel Discussion (Misc queries) | |||
| Relative Reference | Excel Discussion (Misc queries) | |||
Threaded Mode
