Make sure the Faculty Acquisition Lists are all in the same format.

Copy & paste the lists into one document.

Then select the entire table and use

Data/Filter/Advanced

selecting the
Copy to a new location and Unique Items Only options.

This will give you one unique list that can be sorted.

If you have the teachers provide the ISBN's and work off of that field you
can then only create a unique list of that field and use VLOOKUPS to return
the remaining information about the books.

PC



"Garry T" wrote in message
...
I am a librarian in a small independent school. I need to build an
acquistions list from several faculty lists. I would like to type in the
data from each list and make one list that can be alphabetized or arranged
by
vendor, publisher, author, title, etc.