Veeru
05-28-2018, 04:04 AM
Hi,
Looking for a formula or vba code.
i have 2 sheets...........Sheet A told me how many ppl working in one particular cost center
Sheet B has details of these ppls
Cal sheet has their variance
In variance we have a scenario where 1 person leaves and other joins so number remains same.
i need to fing out those persons, id of person who leaves and who joins.
Please suggest something...file attached
Looking for a formula or vba code.
i have 2 sheets...........Sheet A told me how many ppl working in one particular cost center
Sheet B has details of these ppls
Cal sheet has their variance
In variance we have a scenario where 1 person leaves and other joins so number remains same.
i need to fing out those persons, id of person who leaves and who joins.
Please suggest something...file attached