Can you post the original format that was being used? Was there any function setup that controlled the autonumbering? An in worksheet function wouldn't do this automatically. I'm not sure about a format but I don't think so. If you can give me some more details about what the old spreadsheet did or post a portion of it, I'll look at it further.