All,

I'm putting to together a spreadsheet for material requisition for a construction project. These spreadsheets tend to grow very large. Sometimes I need to search for a specific item using a purchase number or description. The filters offer some help but it would be awesome if i could designate one cell where i could input a purchase number or text that searches the spreadsheet and highlights all the hits. Say, Cell N2 is to be my "search cell." can someone help this I would greatly appreciate it.

emondragon 07