I got a 80k lines worksheet and when it was created, people have dragged down fields and Excel have mistakenly auto-incremented some values.
Is there a way to detect if the field was auto-incremented with VBA and change the next row value that was incremented to the current row value?
Something...