hi,
Can anyone let me know how to write a macro which checks the gaps in the records numbering and make it sequential. My Idea was that It should check for the missing numbering in that column. Then check for the highest number and change it to lowest Number+1 and go one incrementing the rows in a column.
There may be morw easiest ways to do this. Can anyone let me know how can we do this?
Thank You,
Pinky
Can anyone let me know how to write a macro which checks the gaps in the records numbering and make it sequential. My Idea was that It should check for the missing numbering in that column. Then check for the highest number and change it to lowest Number+1 and go one incrementing the rows in a column.
There may be morw easiest ways to do this. Can anyone let me know how can we do this?
Thank You,
Pinky