Can you sort data & output to another worksheet?

[Guest]

I'd like to be able to sort a list of data and have the output placed in a
second worksheet, so I can see both the original and sorted lists. The
Data>Sort function does not appear to give the option of placing the sorted
data in another location. Does anyone know a way to accomplish this?

 

[AlfD]

Hi!

You could do it using VBA.

But you might like to try without:

Copy the worksheet within your workbook.
Do the sort on this duplicate sheet.
Now you have the original and the sorted lists at your disposal.

Al