Excell relationship (1 Viewer)

[msi_1985]

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

 

[Murli]

This can be done using a macro. Type the below code and run the macro :
Sub mymacro()
For i = 3 To Sheet1.Range("A65536").End(xlUp).Row
x = Sheet1.Cells(i, 6).Value
Sheet1.Select
Rows(i).Select
Selection.Copy
Sheets(x).Select
rown = Sheets(x).Range("A65536").End(xlUp).Row
Sheets(x).Range("A" & rown + 1).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Cells(1, 1).Select
Next i
Sheet1.Select
Cells(1, 1).Select
End Sub

 

[shades]

Just as ahint, it helps to keep the same thread going rather than starting another one.

http://www.access-programmers.co.uk/forums/showthread.php?t=100830
________
SMOKE KILLS