I have a spreadsheet with multiple worksheets. I would like it to automatically copy information from one sheet to another based on a criteria. The main tab is called "Quoted Work". I have active columns A-D. I set up a column "F" to use as my identifier. If the data entered info Column "F" = Yes then I want it to copy the entire row (not "F") into an existing worksheet named "AwardedJobs". This row should be placed into the next available line as it already contains all of the jobs we are currently working on. I have been researching but just can't seem to get the coding to work correctly. Can you help! Thank you in advance.