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