Adjusting rows versus columns for formulas
 

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
 

In Sheet2, cell G3 enter:

=INDEX(Sheet1!$D$2:$IV$2,1,ROWS($A$1:A1)) and copy down

This, in effect, combines transpose with link.

Have a pleasant day!
--
Gary''s Student - gsnu2007g


" wrote:

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
 

Not sure exactly what you're driving at,
but see whether this gets you there

In Sheet2,
Place in G3:
=OFFSET(Sheet1!D$2,,ROWS($1:1)-1)
Copy G3 down, and you will get the transpose

G
3| Sheet1!D2
4| Sheet1!E2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
...
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
 

Awesome, this is exactly what I needed. Thank you.

On Apr 10, 6:19*pm, "Max" wrote:
Not sure exactly what you're driving at,
but see whether this gets you there

In Sheet2,
Place in G3:
=OFFSET(Sheet1!D$2,,ROWS($1:1)-1)
Copy G3 down, and you will get the transpose

G
3| Sheet1!D2
4| Sheet1!E2

--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
wrote in message

...

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
 

Welcome. But do note that GS' INDEX suggestion also works just as well.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
...
Awesome, this is exactly what I needed. Thank you.