Hi All,

I Have a requirement in Excel, sure this can be achieved, not sure how it can be done, can any one please help me?

I Have Following Data,

Emp_IDEmp_NameMGR1SkNull2ks13sw14abc25abcd3

EMP_ID is unique value no duplicates are allowed,

This is the data I have initially, If I change the emp_id of sk i.e., 1 wherever MGR values is 1 there it should get update with the new value, this should be applicable for new one's too....

if data is known I know how to do it, but for future entries to this table also formula should be populated,

Please can any one help for this requirement,