Adjusting rows versus columns for formulas
 

Not sure which group to post this under, so here it goes... again

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.

Adjusting rows versus columns for formulas
 

=OFFSET(Sheet1!D$2,0,ROW()-3)
in G3 on sheet 2, per my other post in Worksheet Functions with same question.

" wrote:

Not sure which group to post this under, so here it goes... again

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.