Master Form to Database

[soliloquyofastar]

I'm trying to make a database log of all my purchase orders. I have my
purchase order on one sheet, and a log sheet on the next sheet. I only
need certain variables from the PO to go to the database, which are
named date, P.O., vendor, job, item.
What I want to do is for whoever to fill out a PO, be able to save/
close out w/o saving, and have the data they entered go into the log
sheet. then the next po would go on the next line, etc etc.
Any way excel can perform this function?

 

[Shane Devenshire]

Hi,

This is not what spreadsheet functions do. The perform calculations and
return the results to the cell where the function is located.

You would need a macro. And we would need more detail.