How can I paste in the opposite direction?
Thanks for the advise Gord.
However I was looking for something simpler that may exist in Excel in lines
of paste special. I may have to do this frequently and hence qriting formulas
each time would be time consuming.
Thanks again.
"Gord Dibben" wrote:
Don't paste, use a formula.
Enter this in B1 and drag/copy to B5
=INDEX($A$1:$A$5,5-(ROW(A1)-1))
Gord Dibben MS Excel MVP
On Sat, 15 Dec 2007 08:52:01 -0800, Tigerxxx
wrote:
Example-
How can I copy date from cells A1:A5 and then paste them in cells B1:B5 sp
that the data from cell A5 is pasted in cell B1, A4 in B2, A3 in B3, A2 in
B4, A1 in B5?
Please help. Thanks.
|