I have a workbook, with a worksheet that has 2000+ entries. I need to search
column AF, if the value = what I'm looking for, then write that entire line
to a new work sheet. Any help/guidence would be greatly appreciated.