Repeating formulas....

[DanF]

Hi gurus

I hope you can help, and that this makes sense.
I've got some data in one sheet (Sheet 1) in column C which goes from top to
bottom:

(Sheet 1)
C
---------
1| text1
2| text2
3| text3
....

I want to use this this data in another sheet with a repeating formula, but
from left to right not top to bottom. For example:

(Sheet 2)
| D | E | F | ...
-------------------------------
1| text 1 | text 2 | text3 |

When I use a repeating formula, it increments the column and not the number.
Ive used a '$' infront of the column letter - which holds the column but
doesn't increment the number.

Th formula I've tried are as follows:
='--- Config set-up ---'!C1 & "' - Parameters" /* Column changes */
='--- Config set-up ---'!$C1 & "' - Parameters" /* Column stays the same,
row doesn't increment */


I hope that makes sense, thanks for the help.
DF

 

[Bob Phillips]

=INDIRECT("Sheet1!A"&COLUMN(A1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[DanF]

Thanks Bob, will look into that!

=INDIRECT("Sheet1!A"&COLUMN(A1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)