Auto generating sequence number

**DKAbi** · 08-29-2013, 09:09 AM

Is it possible to create a spreadsheet that auto generates a sequence number every time the spreadsheet is opened, or, for example, a button is pressed.

The sequence should have a certain prefix, for example DK-XXXXX-followed by the sequence number, and the user should not be able to overwrite the fields, at least not the output. Finally, the spreadsheet should automatically save the spreadsheet upon exit, so avoid the risk of using the same sequence number more than once.

Is all this possible?

**Tinbendr** · 08-29-2013, 11:30 AM

Search is your friend. Look for incrementing invoice number. That seems to be the most common.
Link one
Linke 2

the user should not be able to overwrite the fields

You can protect only certain cells to prevent overwriting.

**jaslake** · 08-29-2013, 02:19 PM

See this Link

http://www.excelforum.com/excel-prog...utonumber.html

**jaslake** · 08-29-2013, 09:38 PM

Hi DKAbi

Yes, this is possible.

Let us see what you have and what you'd like it to be.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" worksheet that demonstrates what you wish the output to be.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the "Add Files"... button to locate your file for uploading.
6. This will open a new window File Upload...Click "Select Files"
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the "Upload Files" button and wait until the file has uploaded.
10. Click the "Done" Button.