how do I create an Excel formula or that moves to the next row on
 

I have a Purchase Order template that automatically creates the PO Number.
The macro reports the PO number, the end user enters vendor name, and total.
The macro writes the PO number, vendor & Total from the PO to another
workbook - I need have this info recorded and on save move to next line for
the next PO.