Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative addressing with INDIRECT function
Hi group,
Suppose I want to copy this formula: =A1*INDIRECT("Sheet2!a1") To the next cell down, such that the new cell get's the formula: =A2*INDIRECT("Sheet2!a2") If I use the ordinary copy command, the new cell gets the formula: =A2*INDIRECT("Sheet2!a1") which is not what I want. I know there is a way to do this, because I've done it before--but it was a while back. Can someone please refresh my memory? Thanks in advance. -- John Uebersax |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Addressing not working | Excel Worksheet Functions | |||
Indirect function €“ relative column copy/paste | Excel Worksheet Functions | |||
Relative addressing | Excel Worksheet Functions | |||
Relative Addressing | Excel Discussion (Misc queries) | |||
Indirect function - relative reference | Excel Programming |