| 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 |
| 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) | |||
Threaded Mode
