Autonumbers

[roelof bakker]

Hi guys...and also girls,

I have a second issue i'm struggling with, actually 2 issues

One is the auto-numbers. I have a software library which has a form with codes ( with many thanks of tinbendr), the second the library, where i add the records with the form sheet. In the library sheet there is a auto-numbering. Its the intention that every record add get automatically a special nr, this goes fine except the fact that when deleting a row the numbers are changing. like when i give auto nr to pck1 it gets nr 13, when deleting nr 13 nr 14 becomes nr 13 in auto nr. what i want is to keep 14 on his record when 13 has been deleted. reason those numbers are uniek to that sw packet, so it needs to stay static. so when 13 has been removed, it should be 1.2.3.4.5.6.7.8.9.10.11.12.14.15.16. etc. Is this possible if so how. The second, in the form sheet there is a search cell. i need to put in the SW number (autonr from library) and when i press the delete button, it should delete the row with the nr in it, so it has to bel linked somehow and i just dont know how.

If any body can help me with this ill be great-full

[ragulduy]

I would suggest adding:

Please Login or Register  to view this content.

to change the item number in column J to a value rather than a formula so it doesn't update itself. The full macro would then become:

Please Login or Register  to view this content.