Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assistance with Alphabetizing a Library Worksheet
Goal: To have the option of an alphabetical list of books by titles or an
alphabetical list of books by authors. Problem: Column A lists the book titles. Column B lists the authors. These must obviously stay together. When column A is alphabetized, how do I get column B to follow column A and visa versa? (column C is Checked-Out, column d is Checked-In, column E is church member name) Therefore, the ultimate goal is to be able to change the worksheet to glance and see who has a book out (by bringing all the checked-out to the top, or any alpahbetized list needed. Microsoft Excel 2000 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assistance with Alphabetizing a Library Worksheet
Just be sure to select the entire range of values before sorting. That means
columns A through E "bandre" wrote: Goal: To have the option of an alphabetical list of books by titles or an alphabetical list of books by authors. Problem: Column A lists the book titles. Column B lists the authors. These must obviously stay together. When column A is alphabetized, how do I get column B to follow column A and visa versa? (column C is Checked-Out, column d is Checked-In, column E is church member name) Therefore, the ultimate goal is to be able to change the worksheet to glance and see who has a book out (by bringing all the checked-out to the top, or any alpahbetized list needed. Microsoft Excel 2000 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assistance with Alphabetizing a Library Worksheet
bandre
You can sort on any column you wish. IMPORTANT.........just make sure you have selected all columns before sorting. Do not let Excel guess what your range is. Having said that, I will now say that DataFilterAutofilter would be a better tool to use in your case. You can then filter for just the Book or Author or Checked in or Checked out or Member Name. Gord Dibben MS Excel MVP On Thu, 18 Jan 2007 09:31:05 -0800, bandre wrote: Goal: To have the option of an alphabetical list of books by titles or an alphabetical list of books by authors. Problem: Column A lists the book titles. Column B lists the authors. These must obviously stay together. When column A is alphabetized, how do I get column B to follow column A and visa versa? (column C is Checked-Out, column d is Checked-In, column E is church member name) Therefore, the ultimate goal is to be able to change the worksheet to glance and see who has a book out (by bringing all the checked-out to the top, or any alpahbetized list needed. Microsoft Excel 2000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I replace a worksheet with lists | Excel Worksheet Functions | |||
I need to copy a text value from one worksheet to another | Excel Discussion (Misc queries) | |||
Best Approach to Worksheet Synchronization | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) |