If you're using Excel 2002, or later version, you can paste the numbers
from the Office Clipboard.

To view the clipboard, choose EditOffice Clipboard.
After the sort, select another cell where you want to paste the data.
Click on the item in the clipboard.

Rodney wrote:
I need to copy a column of 40,000 numbers to the clipboard,
using Excel as a database, carry out 12-15 sorts
dropping the clipboard contents into vacant columns as I go.

After I try a sort, the paste option no longer offers.
Any explanation? please.






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html