auto fill ID NUMBER on EXCEL

[cenii]

hello i want to create an table and on Column that i will call ID NUMBER i want to autofill from 100

[Whizbang]

Assuming your first row is a header,

Please Login or Register  to view this content.

Or just place 100 on your first record and on the next record put

Please Login or Register  to view this content.

The problem with a formula approach is that sorting messes up the IDs. If that is a problem for you, you'll want a VBA approach.

Please Login or Register  to view this content.

You'll want to put in some additional checks and error handling to accommodate changing multiple records at once, deleting a record, or any other shenanigans users might get up to.