"In the header of each column I would like to have a drop down containing the data in each column,"
I'm not quite sure i understand the use of the menu in this description.
But for the second option, Yes, the search filtering would be possible, it would require creating separate recordset to feed each drop down menu.