John

You cannot sort two sheets simultaneously.

Not knowing what your lists look like, it is hard to make a suggestion.

Perhaps copy/paste the list from sheet2 over to sheet1 in columns to the right
of existing data.

Then select all columns of data and sort.

More detail on the lists from you will garner a better response from all.


Gord Dibben MS Excel MVP


On Thu, 19 Jan 2006 13:47:05 -0800, John N <John
wrote:

I have a list of multiple columns that is on two sheets in an Excel 2002
document. How can I sort the data on both sheets so the data is all in order?