Excell relationship

[IRSATH]

Dear All.
I have been following my company Employee's data list on the excell sheet.
I have 4 type of employees

1- Aramco Employees
2- WUR Employees
3- TUR Employees
4- Office Employees

in excell sheet
1 sheet is All employees list
2 sheet is WUR
3- Tur
4- Office

My quetions.
1- When i add new employee data list on the (ALL employee Shet "1 sheet")
it want go relative sheet.

EX:- Name - Irsath
Unit - Aramco


Now i update on the 1 sheet ( All employee list), when i update on the sheet also it want update on the "Aramco Sheet " Automatically.

How can do it ?

your feedback is highly appreciated.


Thanks
Irsath moahmmed

[Bob Phillips]

Here's a quick example

[IRSATH]

Dear XL.

Thanks for ur answer.

Welcome.
Irsath mohamed

[IRSATH]

Dear XL.

Your example is correct,
We couldn?t performed, so pleas explain how did?

Thanks.
irsath mohammed
Please see tha attachmet,

[Bob Phillips]

Try this