| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Relative reference won't update
Your F2 is inside the quotes and is therefore treated as a string and
does not increment. Try this instead: =INDIRECT("Database!$F"&ROW(A2)) and then copy it down as required. Hope this helps. Pete On Dec 20, 1:31*am, "LaborGuyRJ" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Relative reference won't update
That was the solution. Thank you so much
Bob "LaborGuyRJ" wrote in message .. . 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Relative reference won't update
You're welcome, Bob - thanks for feeding back.
Pete On Dec 20, 4:59*am, "LaborGuyRJ" wrote: That was the solution. Thank you so much Bob |
| Reply |
| 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) | |||
Linear Mode
