Hi i have this excel database with numbering
1. data
2. data
3. data
4. data
whenever i delete example number 2. it will ruin the numbering
1. data
3. data
4. data
how can i make it auto adjust the numbering if i delete some rows
here's my vba code on delete.
Please Login or Register to view this content.
Last edited by Pepe Le Mokko; 04-29-2020 at 08:23 AM. Reason: Replace quote with code tags
This will give you an idea...Delete any row in sheet
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
thank you so much
Pleasure...Tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks