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.


--
nmccart
------------------------------------------------------------------------
nmccart's Profile: http://www.excelforum.com/member.php...o&userid=35870
View this thread: http://www.excelforum.com/showthread...hreadid=556622