Automatically duplicate and sort data into seperate w.sheet
 

My document consists of two worksheets.
The first is the sheet where I input data and the second is exactly the same
except that it is 'sorted' (i.e. 'sort data'). Currently I do this manually
but i suspect that it's possible to set up the second sheet to automatically
duplicate and sort the data from the first sheet.
I'd be grateful if anybody could tell me how.

Automatically duplicate and sort data into seperate w.sheet
 

I don't have a suggestion for your question--but I'd stop using two sheets and
just sort the data in the one and only worksheet.

Ting wrote:

My document consists of two worksheets.
The first is the sheet where I input data and the second is exactly the same
except that it is 'sorted' (i.e. 'sort data'). Currently I do this manually
but i suspect that it's possible to set up the second sheet to automatically
duplicate and sort the data from the first sheet.
I'd be grateful if anybody could tell me how.

--

Dave Peterson