Master Form to Database

  • Thread starter Thread starter soliloquyofastar
  • Start date Start date
S

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?
 
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.
 
Back
Top