| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a function to match up jobs
I have a master sheet with about 50 different job descriptions, then I have
about 20 more worksheets that could have between 20 and maybe 40 job descriptions with the number of people against them. I want to put them all on the master sheet against the appropriate job description but keeping them in columns against their appropriate worksheet without having to go through and enter everything manually. Master Sheet Worksheet1 Worksheet2 Accountant Accountant 40 Bookkeeper Bookkeeper 15 Bookkeeper 20 Finance Manager Finance Manager 12 General Clerk General Clerk 20 Etc. I hope this all makes sense. Thanks in advance Lynda |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel print jobs | Excel Discussion (Misc queries) | |||
| jobs | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Need help on my Jobs applied too SS | Excel Discussion (Misc queries) | |||
| print jobs | Excel Discussion (Misc queries) | |||
Threaded Mode
