Automatically duplicate and sort data into seperate w.sheet

T

Ting

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.
 
D

Dave Peterson

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.
 
Top