The macro uses formula in column T of sheet3 to flag occurances of multiple serial numbers that have a PASSED status.

It then goes through column T and copies serial number and date to FTP sheet.