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 OR
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?

[Palmetto]

It would be best if you posted your workbook so others can see the actual structure of the PO sheet.

Below is very basic code to copy cells to another sheet. There are more efficient ways of going about this, but I used this approach only to illustrate the concept, not as a specific solution.

Please Login or Register  to view this content.