Moving Data from one sheet to another
We have a 'Request for Quote' process where a customer will ask us to quote them on fabricating some weld work. We place this information in a sheet "RFQ" Sheet, with Unique Quote Number, Product Name, Start date, End Date, Company requesting quote name, Project Manager Name, Internal Project Manager Name, Outsource Needs, Amount.
If we win the bid I would like to click a YES/NO selection and then this information would need to migrate to another sheet that would be our "Awarded Orders".
Is there and easy way to do this?