If you have headings for your lists:

BookName AuthorName CatName
Book1 Author1 Categ1
Book2 Author2 Categ2
Book3 Author3 Categ3
Book4 Author4 Categ4

And your criteria list uses the same heading:

BookName
Book1
book2

And you assign the name "database" to all of the main list, including
headers

And you assign the name "criteria" to the criteria list, including the
heading,

then you can use this macro:

Sub DataDelete()
ExecuteExcel4Macro "data.delete()"
End Sub


This uses an old Excel 4 technique that is no longer part of the Excel user
interface but is still supported beneath the surface.

--
Jim Rech
Excel MVP