| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Sequecing in New Work Sheet
Hello Guys,
I hope I could get some help! I have an excel work-sheet, on the top-right corner of which there is field called "PURCHASE ORDER #" with puchase order # 10001 The file is saved with the same name as its purchase order (10001.xls). IS THERE A WAY TO AUTOMATICALLY PUT IN NEXT-IN-ORDER PURCHASE ORDER # ON THE NEW .XLS SHEET AS SOON AS YOU OPEN IT i.e. if the old sheet yo saved had number 10001, could we make new .xls sheet that we open, hav 10002 as default in the Purchase order field and so on. Also, could we save the newly opened file at a location without hittin "Save" or "Save-As", with that new number (10002.xls) ? Thanks, Your help and advise will be sincerely appreciated -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto PRINT file path & Date on Excel work sheet ? | Excel Worksheet Functions | |||
| Auto Copy Text from one work sheet to another | Excel Worksheet Functions | |||
| extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
| auto numbering an exel work book sheet everytime it opens or print | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Threaded Mode
