Sorted data on separate sheets

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