Move sorted data from one worksheet to multiple worksheets?
 

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?

Move sorted data from one worksheet to multiple worksheets?
 

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

On Oct 4, 2:12 am, Mark wrote:
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?