Move sorted data from one worksheet to multiple worksheets?

M

Mark

Hello. I am importing a tect delimited file into Excel (no problem there) and
then I need to sort the data and move the data to new worksheets based on the
criteria. Anyone able to help?
 
P

Pete_UK

Highlight all your data (including headings) and click Data | Sort -
in the panel check which column(s) you want to sort on and the sort
order, and click OK when set.

Then you can click on Data | Filter | Autofilter, and you will get
pull-down arrows for each column. From these you can set criteria for
the appropriate column(s). When you highlight and <copy> the filtered
data, only the visible data will be pasted into another sheet.

Hope this helps.

Pete
 
Top