Hey, I was wondering if you Excel Gurus could give me a hand. My mother is making a list (in Excel) of all of the books in the church library. The church would like to see each book sorted by titles on a tab for each letter of the alphabet. So, she has created a workbook with 26 worksheets, each one is labeled with the letter of the alphabet (A, B, C, etc). On each sheet, the Title is in Column A, the Author is in Column B, and the Book Categoy is in Column C.
Is there a function that can be written to go through each sheet (A - Z), and sort the data on a summary sheet (a 27th tab) by the Category (Column C of each sheet)?
If this is possible, I'd love to see how. My Excel programming knowledge is just enough that I know this could be done, but I am not sure how to work it.
Bookmarks