Sorted data on separate sheets

**Wibs** · 10-28-2011, 08:34 AM

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

**royUK** · 10-28-2011, 09:17 AM

This doesn't seem like a good idea.

You could do it with macros, but if a user opens the workbook without enabling macros & makes entries then problems!!

Stick to one sheet with data & filter, sort as & when required

**Wibs** · 10-30-2011, 08:47 AM

Originally Posted by royUK

This doesn't seem like a good idea.

You could do it with macros, but if a user opens the workbook without enabling macros & makes entries then problems!!

Stick to one sheet with data & filter, sort as & when required

Users will not be able to open the workbook without macros enabled, so that is not a problem (it is a shared workbook, but read-only). So my question still stands. How to make Sheet 2 = Sheet 1, and how to sort Sheet 2?

Thanks

Wibs