| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a column to automatically number the next row
I am trying to upload a great deal of vendors into a new accounting package,
but I cannot use the old vendor number format in the new software. I would like Excel to automatically assign vendor numbers based on the first letter of the vendor name. Taking that letter and simply add one number to the previous vendor. Such as A000001, then A000002, etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I automatically update column index number in VLookup whe. | Excel Worksheet Functions | |||
| Formula to automatically change one number to another number | Excel Discussion (Misc queries) | |||
| How to automatically number an index column | Excel Worksheet Functions | |||
| AUTOMATICALLY CHOOSE COLUMN H OR G DEPENDANT ON CONTENT IN COLUMN. | Excel Programming | |||
Threaded Mode
