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""
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++
nayeemoddin wrote in message
...
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