Do we need this code?
Because every day while entering data we have to insert some row or the other. If we have data in lakhs then we will need VBA CODE for it, using which the speed of work will increase. This is a time management process.
SOME Pictures
Demo Images
If there was data of lakhs, then if a new row is inserted in the middle of any row, it will not be known. For this, you will have to go to cell number 1 again and double click, then it will happen. This is a time taking process, so we providing a VBA Code just it copy and paste to and Enjoy.
1. Just click to Developer Tab
2. Click to Visual Basic (Alt+F11)
3. Select the Module1
4. Write this code
5. Click to Developer Tab and Click to following Arrow instruction.
6. Insert the Button1
7. Right Click and click to Assign Macro
9. Ok
10. Just entry the data B1 column have entry data
11. Button1 click to generate automatic serial number A1 to last data have.
Tags:
Auto Serial Number