Master Form to Database

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top