Hi any help would greatly be appreciated - i have on Sheet1 many customer details eg name, company, telephone, email address, job requested, quote given etc and Outcome. I want to copy to Sheet 2, customer name, company, telephone, email, and job requested only if the Outcome is "Accepted" - this part i have managed to do with a simple If function. However the problem is that on Sheet 2 i only want to copy over accepted jobs one after the other which i cannot get to work. my formula scans each row and returns the correct information if Outcome is Accepted otherwise returns FALSE can anyone please assist Thank you in advance.