How flip a selection before pasting - Paste special

How flip a selection before pasting - Paste special

Post by cnVrc » Thu, 01 Jun 2006 16:38:02


Hi all,

I want to invert a selection in a column before pasting it.
For eg: I have a whole lot of info from Row A1:A45
When I paste it into column B, I want it to flip; i.e.: the selection to
inverthat is, the contents of cell A45 to go into B1, A44 to go into B2 and
so on till I get A1 in B45.
I need to do this a number of times so would rather not do a concatenate
with numbered rows, sort ascendng/sort descending and un-concatenate agian...
is there something you have seen that could help?

I don know if this can be done but over the past week I wonder why it has
not been provided for and I wonder why there is help topic so I can figure
this out on my own.

thanks!
 
 
 

How flip a selection before pasting - Paste special

Post by Roger Govi » Thu, 01 Jun 2006 16:49:29

Hi

One way
Enter in B1
=INDEX($A$1:$A$45,46-ROW())
Copy down column B as far as B45

--
Regards

Roger Govier

 
 
 

How flip a selection before pasting - Paste special

Post by cnVrc » Fri, 02 Jun 2006 02:38:02

Roger, Thank you so much! It works and has made things much easier for me!