Re: Auto Update a number as in accounting packages
Regarding your query on how to go about...
Assuming you have problem in having this code placed in a workbook module..follow the below steps:
1. Have file saved as template(as suggested by Batman)
2. Press Alt+F11 to go the VB editor
3. In Insert menu slect module to insert a module
4. Copy the code and paste it blindly into the module(font with blue are key words and as such you need not do anything on that)
5. As instructed by Batman you should have created a text file before doing all the above or before running the code
6. come to excel again pressing Alt+F11
7. Press Alt + F8 and select the macro and press run..
Hope this is what you are loking for..