Copying function between 2 worksheets -- horizontal to vertical

[scoobydude]

I am trying to copy the cells from one worksheet to another. For instance, the worksheet I am copying from has the cells listed horizontally: D22, E22, F22, G22, etc. I am trying to get those values copied to the other worksheet listed vertically: A4, A5, A6, A7.

What I would like to do is create a formula to copy the values in D22 into A4, D23 into A5, D24 into A6, etc. How do I do this?

 

[JoeMo]

I am trying to copy the cells from one worksheet to another. For instance, the worksheet I am copying from has the cells listed horizontally: D22, E22, F22, G22, etc. I am trying to get those values copied to the other worksheet listed vertically: A4, A5, A6, A7.

What I would like to do is create a formula to copy the values in D22 into A4, D23 into A5, D24 into A6, etc. How do I do this?

The second paragraph of your post seems to contradict the first paragraph.

Assuming you want D22 in A4, E22 in A5, F22 in A6 and so on, take a look at the TRANSPOSE function in Excel's Help.

 

[Willmonbo]

you can use this simple formula in in cell A4 and drag it down to as many cells as needed.

=INDEX($D$22:$G$22,,ROW(A1))

remember to reference the sheet names as well if they are on different sheets.

 

[scoobydude]

The second paragraph of your post seems to contradict the first paragraph.

Assuming you want D22 in A4, E22 in A5, F22 in A6 and so on, take a look at the TRANSPOSE function in Excel's Help.

yea, sorry about that. It would be in Row 22 only.

 

[scoobydude]

you can use this simple formula in in cell A4 and drag it down to as many cells as needed.

=INDEX($D$22:$G$22,,ROW(A1))

remember to reference the sheet names as well if they are on different sheets.

excellent, thanks. i will try that.

 

[T. Valko]

I am trying to copy the cells from one worksheet to another. For instance, the worksheet I am copying from has the cells listed horizontally: D22, E22, F22, G22, etc. I am trying to get those values copied to the other worksheet listed vertically: A4, A5, A6, A7.

What I would like to do is create a formula to copy the values in D22 into A4, D23 into A5, D24 into A6, etc. How do I do this?

Try this...

Entered in A4 and copied down as needed:

=INDEX(Sheet2!D$22:H$22,ROWS(A$4:A4))

Adjust for the correct end of range H$22.