Query about sort

[owendodd]

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!

 

[RalphA]

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.