Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increment cell reference
=INDEX(INDIRECT("'"&$A3&"'!$G5"),COLUMNS($A:$A))
How can I get the variable, "G5" to increment when copied across a row or down a column (i.e., $G5, $G6, $G7, etc) I've tried copy and then paste special, formula, but it doesn't increment. What should I be doing? Thanks Larry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increment cell reference
You have to move the 5 outside the quotes for it to increment, eg:
=INDEX(INDIRECT("'"&$A3&"'!$G"&ROW(A5)),COLUMNS($A :$A)) as this is copied down then the ROW(A5) (returning 5) will become ROW(A6), ROW(A7), ROW(A8) etc, returning 6, 7, 8 etc Hope this helps. Pete On Apr 8, 1:28*am, "Larry Kahm" wrote: =INDEX(INDIRECT("'"&$A3&"'!$G5"),COLUMNS($A:$A)) How can I get the variable, "G5" to increment when copied across a row or down a column (i.e., $G5, $G6, $G7, etc) I've tried copy and then paste special, formula, but it doesn't increment. What should I be doing? Thanks Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - How to increment cell reference by one row | Excel Worksheet Functions | |||
How do I get a worksheet reference to increment when copied | Excel Worksheet Functions | |||
Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) | |||
how to make cell address reference increment? | Excel Worksheet Functions | |||
Row reference increment but preserve column reference | Excel Worksheet Functions |