do sort and put answer in another location?

[Neophyte]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

is there a way to 'sort' 'A1-A5' and put the new sort in 'B1-B5'?

 

[CyberTaz]

Copy & Paste after sorting?

If you need a more extensive answer please ask a more descriptive question.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Bob Greenblatt]

Copy & Paste after sorting?

If you need a more extensive answer please ask a more descriptive question.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Or, what I think he means is to copy before sorting and then sort the new
area.

 

[CyberTaz]

Yeah, well, that's kinda my point - it's totally unclear what is wanted

I was just hoping to draw a clearer explanation... I'm not even sure why
you'd need 2 copies of the same data stored in the same sheet in opposite
sort order in the first place.

Regards |:>)
Bob Jones
[MVP] Office:Mac