Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort a list that is on two sheets?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort a list that is on two sheets?
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make Excel sort and graph a list of numbers? | Charts and Charting in Excel | |||
Can I sort a list with more than three fields? | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
Why doesn't the File Open list sort into filename order? | New Users to Excel |