Copying sorted data and then paste

B

birdieall

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have data on a sheet (about 120 x 10) I'm using the autosort on each column and then sorting. When I try to paste this data on a second sheet or email, I get all the data previous to the sort pasted on second sheet or email. Anyone else having this problem?
 
P

Pat McMillan

Could you please give us more detailed steps, or send a file? It's not
completely clear to me from your description what problem you're having.

Thanks,

Pat McMillan
 
P

Pavel

Also try Autofilter and filter some data. Then copy and paste these filterd data and you will get all of them! Unbelievable...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Sheet loses format when paste new data 2
AutoSort by Field in Pivot not working 0
copy and paste from exel 6
crash on autosort 1
unable to paste data into Excel 3
Hyperlinks to sheets within one workbook 1
UNABLE TO DATA SORT DUE TO CELL SIZE VARYING 3
Leading subheads for sorted data 2

Top