You can create your own VBA code to do that, and can either assign it to a keyboard shortcut, or have it run automatically.
If you want it to run automatically, we will need to know a few details, such as:
- Is this code going to actually be in the workbook you are saving and closing?
- How should this work? What exactly"constitutes" completion of the data entry?