Query about sort

owendodd

Board Regular
Joined
Jan 17, 2005
Messages
205
Hey i would to know how you can paste sorted information! Firstly i have sorted a table into group then once this is done i wish to just pasted that sorted information into another sheet!When i simply paste or go to any of the other options paste special it seems to drag over everything that was unsorted! Any ideas please!
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
After sorting, highlight what you want to apear on the other sheet, then do a Copy, go to the other sheet, do an Edit, Paste Special, and select Values, OK. Ifthis doesn't do it, please post a simpleexample, plus a clear description of what you want to appear on the other sheet.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,123
Messages
5,576,227
Members
412,709
Latest member
AD04
Top