Hi,

I have a single spreadsheet within a workbook containing data that is similar to employee records: Forename, Surname, Department, Extension. All the data is in Sheet 1.

What I would like to do is to have Sheet 2 to be a copy of Sheet 1, but sorted according to Surname, and Sheet 3 to be a copy of Sheet 1 but sorted according to Department, etc. Of course, if Sheet 1 is edited then the copies on Sheets 2 and 3 would reflect this.

What is the simplest way to achieve this?

many thanks

Wibs