Find a value and link to another sheet

[massel4]

Hi,

I'm having problems with VBA and I was wondering if any of you would be able to help...

So, I have a worksheet named "Liste" (everything's in French, but it shouldn't matter) in which I list all the employees, their employee number, their department number, and all the mandatory training they have to do during the year. Then, for each department, I have a seperate worksheet to tally the progress being made by the employees of that particular department, so the director of the dept. can monitor his/her employees.

What I need a macro to do is find every employee in dept. 004 and list them in my 004 Worksheet, and then link the cells next to their name on Worksheets("Liste") to the cells next to their newly copied name on worksheets("004")... I would also need the macro to update immediately if I add a new employee in that department, and put it a the end of my list... same thing if I remove an employee
I made a simple mockup here (in the actual worksheets, there are a lot more classes, employees, dept., etc.)

Thanks for any help... and if you need any more informations, I'll gladly provide them...


This would be Worksheets("Liste")

	A	B	C	D	E	F
1	Dept.	Name	Class1	Class2	Class3	Class4
2	004	A
3	007	B
4	004	C
5	018	D

<TBODY>
</TBODY>

And this would be the end result in Worksheets("004")

	A	B	C	D	E	F	G	H
1
2				Name	Class1	Class2	Class3	Class4
3				A	=Liste!C2	=Liste!D2	=Liste!E2	=Liste!F2
4				C	=Liste!C4	=Liste!D4	=Liste!E4	=Liste!F4
5

<TBODY>
</TBODY>