HELP!! Excel Copy and Paste.

[Art]

I need to be able to copy a range of cells in a column
into another column so that the order of the cells is
reversed. For example, if I copy A2 to A5 into B6 to B9,
I would want the contents of A2 to now appear in B9, of
A3 in B8, and of A4 in B7, and of A5 in B6. Does anyone
know of a simple way to work with the copy and paste
functions in the edit menu to accomplish this?

I have just spent an incredible amount of time using
the "office Assistance" resources without any luck. Any
help on this would be greatly appreciated!

Thanks!

 

[Roger Govier]

Hi Art

Try entering in B6
=OFFSET($A$2,5-ROW(1:1),,,)
and copy down