Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Departments in one cell
Hi,
I am working in the HR department in a BPO Industry. Last week, my manager has given me a tedious task. I have to prepare employee master of 5000 employees of around 85 different processes. I have prepared that sheet by combining many existing sheets. Now, I have to update that sheet on daily basis but the problem is in maintaining the Process Column, because as per the process need, may be one has to change his process more than 50 times in a year or not even one time. Now if I will insert 50 columns in that sheet it will become very huge and confusing sheet for me and others as well because it is already a very big sheet having each and every detail of an emplyee. I want to know is it possible to enter all the processes in one single cell and until we reach to that particular cell it should show the last process (means current process in which he is working) and if we reach to that particular cell it should show the whole process he was moved from one department to another. For example- If one join process (A) then move to process (B) then (C) then (D)-(E)-(F)----(Y) and at last if he is working in (Z) then cell should show (Z) but the moment I reach to that particular cell it should show (A)-(B)-(C)-(D)-(E)-(F)------(Y)-(Z). It is not necessary that it should be in the same process, if you understand my problem you can suggest me different ideas to solve this problem. Note-I have to use regularly the Vlookup for taking the current department in other different sheet. So, it should be flexible for this. Thanks & regards Jai |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
Would like a Template to conduct process review for departments | Excel Discussion (Misc queries) | |||
cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
How to monitor productivity within departments using Microsoft Exc | Excel Worksheet Functions |