| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to automatically number order forms in excel upon opening?
I have generated an order form in Excel 2003. Each time the form is opened I
would like for the cell entitled, "order number", to be filled in automatically with the next number in the sequence so that we do not duplicate numbers. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to automatically number order forms in excel upon opening?
I had a very similar conversation on this NG last week- you should be
able to adapt this to suit your needs: http://groups.google.com/group/micro...7d46b164f9 7d |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to automatically number order forms in excel upon opening?
Go to http://www.mcgimpsey.com/excel/sequentialnums.html for your solution!
"Mike1" wrote: I have generated an order form in Excel 2003. Each time the form is opened I would like for the cell entitled, "order number", to be filled in automatically with the next number in the sequence so that we do not duplicate numbers. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I generate the excel chart with out opening the excel instance? | Charts and Charting in Excel | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| can excel change number 1532 to 1235 running order | Excel Discussion (Misc queries) | |||
| How does excel automatically covert cells when a different number. | Excel Discussion (Misc queries) | |||
| Excel Forms - text fields decompressing font automatically | Excel Discussion (Misc queries) | |||
Linear Mode
