| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To assign list of number
I have a range of date which consists of Job number & cost code. I want to assign the Job Description based on the job number & cost code. What i did before is to manually fill in the Job description, which is kind of wasting time when the list is long. Is there a code to automate this process? Job Number Cost Code Job Description A120-BDL 01-A120-BD Project 9000-000 07-9001-000 Quality 9000-000 09-9002-000 Functional A291-ARL 01-3000-000 Project A120-BDL 01-A120-BD Project A291-ARL 01-3000-000 Project 9000-000 07-9001-000 Quality 9000-000 09-9002-000 Functional A120-BDL 01-A120-BD Project A291-ARL 01-3000-000 Project 9000-000 07-9001-000 Quality 9000-000 09-9002-000 Functional 9000-000 02-9001-000 Others A120-BDL 01-A120-BD Project A291-ARL 01-3000-000 Project 9000-000 07-9001-000 Quality 9000-000 09-9002-000 Functional 9000-000 01-9001-000 Others 9000-000 09-9002-000 Functional 8666-FDL 02-8666-FD Project |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign a number each letter on list compounding occurence @ each e | Excel Worksheet Functions | |||
| List of Dates- Assign Week Number?? | Excel Discussion (Misc queries) | |||
| Assign one number to a number range | New Users to Excel | |||
| assign number value | Excel Programming | |||
| assign number value | Excel Programming | |||
Threaded Mode
