Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Auto assigning
I have 7 columns, they are Date - Req. Number - Requestor - Dept. - Notes - IOU,Yes/No - Status The departments have a req. number assigned to that dept for tracking and I have sorted the sheet to keep the depts. together. The date arrangement doesn't matter because it's for the month. Shaw - 001 Shaw - 002 Maint - 001 Maint - 002 and so on. When I type the "Maint" in the department, I want to auto generate the next number like Maint - 003 for whatever department, I can sort the data myself onless someone can tell me how to do both automatically. If this can't be done maybe if I had something to work with I might be able to figure it out. -- jackel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto filter through the Comman Button | Excel Worksheet Functions | |||
any formula to auto calculate 1st-12th is 12 days pls? | Excel Discussion (Misc queries) | |||
Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
Macro for Auto Fill | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |