how to paste the values in reverse order in workbook

[Guest]

hi,
after copying the cells, how to paste the copied cells in reverse order
ex: 1
2
3
i want to paste these cells in this order
3
2
1

 

[Rojee]

It would be best to sort the number in descending order
after you paste the copied data.

Rojee

 

[R.VENKATARAMAN]

this solution was given by an MVP(sorry I forgot to note the name)
suppoe your data is in B1 to B16

in some other cell(e.g. D12) type this formula

=OFFSET($B$1,MATCH($B$16,B1:B16,0)-1,0)

copy d12 down till #N/A appears. Remove cells containing ""N./A""
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++