Adjusting rows versus columns for formulas

[joshua.olson]

Sorry, for posting this in multiple forums, but I just found this one.

I'm trying to find any way to adjust the row when I paste the formula
in the next column or visa versa.

I would be willing to use indirect references, but transposing my data
would not work well as the data displays much better in the formats
they are in.

Ex. On first worksheet the data is like
D E F G
2 | 25 50 39 27 ....

and the second worksheet I'd like it to be

G
3| Sheet1!D2
4| Sheet!E2
5| ....

I don't really care what method I use to do this, but I'd rather not
have to write a visual basic function to translate between the cells.

 

[JLatham]

If you put this in G3 on the second sheet and fill down, it should do the job
for you:
=OFFSET(Sheet1!D$2,0,ROW()-3)

You'll have to continue filling the formula down the sheet as you add 'new'
columns of data on the first sheet.