Hey, guys new to sheets and I am enjoying using to simplify my bookkeeping for work.

I send out prices and proposals and I track (DATE, NAME, TOTAL PRICE, and PO#) each time I send out a proposal and then I add if they are accepted Yes or No at the final column.

If they are accepted I have to manually transfer over to my invoice sheet the information for the Row of data that I have already entered (Date, Name, Price Total, and a PO#)

Just Wondering if there could be a way to make it if YES is on the final column, to transfer the information on its own to the next available open row. I'm not sure which direction to look but if you have any template maker$, tips, leads, or information on how to do, that'd be great!

​

​

https://docs.google.com/spreadsheets/d/1SS4Wu-aeVqK7Eae8c_abj4geFdOvS24KVw5xpsGXk6w/edit?usp=sharing