Pulling info from Column going down into column going up

[dbogey]

I am trying to pull a column of cells from one sheet into another column in another sheet, but the first column goes down, I need the second column to go up.

How do I copy D6:D372 into B366:B1?

I hope this is clear, if not let me know.

Thanks for the help.

[hemesh]

do you want value of D372 into b1 and so on

[dbogey]

I need value of D6 into B366, D7 into B365, etc

[hemesh]

try below in B1 and drag down
=INDEX($D$6:$D$372,367-ROW(A1))

[dbogey]

Thanks, I am sure I'm doing something wrong referencing another sheet:

=INDEX('[Model Totals.xlsx]2016'!$D$6:$D$369,367-ROW(A1))

It returns: #REF!

[hemesh]

you need to use
=INDEX($D$6:$D$369,364-ROW(A1))

[dbogey]

Thank you for the quick solution

[hemesh]

@ dbogey you are welcome and thanks for the rep