Automated log from Purchase orders

[Angel1111]

Hi I tried to find this information all over the place and I hope someone here can help me.

I don't know much about VBA in excel so please be patient. I have an excel purchase order template that automatically generates a new PO# when its opened, so far so good.
I would like upon closing it to save each purchase order separately in a folder and then automatically populate a log with date and po# in a separate sheet when the workbook is closed or when I click a button whatever is easier.
Practically I want to keep track of these purchases orders by logging them somewhere.

Also can there be a safety feature in case i close the sheet by mistake? if not data is entered it should give me an error message?
Sorry I know it is a lot but please help!

Thank you in advance.
Angela

[Richard Buttrey]

Hi, and welcome to the forum.

Yes of course all you ask about is perfectly do-able. Upload the workbook for specific help.

Just a thought, but given all (presumably) the order data will be stored in the log is there any need to save the file? I'm assuming as part of your process you will either have printed or emailed the order. Should you ever need to recreate an order it would be a simple matter to prompt for an order number and have the template filled with the data from the log.