View Single Post
  #3   Report Post  
Roy Wagner
 
Posts: n/a
Default

Pick or add an empty column to use as a helper column. Using the same rows as
your data to be sorted, number them from 10 to 1.

Select the data to be sorted including your helper column. Be careful about
other data on the sheet. If you have data in other columns, it all needs to
be sorted together to keep your data intact.

On the menus select DataSort Select you helper column, xlAscending and no
header row. Click sort. Done. Get rid of the helper column/numbers.

Roy
--
(delete .nospam)




"vpedchenko" wrote:

Ie, if i have a set of 10 numbers in column A, how to copy the into column B
in reverse order?