Excell relationship

Dear All.

I have 5 worksheet
1 - All employees data ( wur + tur + aramco + office )
2- WUR emplyees data
3- TUR employees data
4- ARAMCO employees data
5- OFFICE Employees data.

My quetions.
1. When i update one employee data ( Ex; mohammed irsath ., he is ARAMCO Employee) on the All employee sheet ( 1 sheet) it want update autamatically to relative sheet.( Aramco Sheet ).


please see the attachment.
How cann i do it?

Please send ur feed back

Firstly, no attachment. Secondly, use a Pivot Table on sheets other than your "All Employees" sheet. This way you can easily filter/update the information.

I would agree - and it allows data to be changed in one place. Of course, it depends on who has access to the data and how it is being used.

You can do it with formulas, but for an overhead and maintainability cost. But an attachment would be helpful.
________
FORD FUSION (EUROPE)