Copy and Paste Values in reverse order

[Yandeez]

Hi,

I'm looking to copy the values of the attached and paste them into the lower grid in reverse order. Any easy way to do this?

 

[Mike H..]

Hi,

I'm looking to copy the values of the attached and paste them into the lower grid in reverse order. Any easy way to do this?

Hi,

Put the formula below in D8 and drag right. If you want then you can copy these values then paste special - values.

See your workbook.

=INDEX($D$4:$H$4,COLUMN($E$5)-(COLUMN(A1)-1))

 

[ONKAR BHOSALE]

nice one