I have an database consisting of 16 columns that will be periodically updated. I was wondering if there was a way for me to search through the first column which is equipment's names with several dupilcates and have it be pasted it another sheet with the information form columns 2,5 and 6 automatically. Please help I have tried all the ways I could think of.