Excel macro to increment the value by on from on sheet to other

[banu_prashanth]

I have two sheet in sheet1 i have department and question

	A	B	C	D	E	F	G
Q1	4	4	4	4	4	4	4
Q2	4	2	3	3	4	4	4
Q3	4	1	3	3	4	3	3
Q4	4	1	3	4	3	3	3
Q5	4	2	2	3	3	3	4
Q6	4	4	4	4	4	4	4
Q7	4	3	3	3	4	3	3
Q8	4	2	3	3	4	3	4

<colgroup><col style="width:48pt" span="8" width="64"> </colgroup><tbody>
</tbody>

In the other sheet i have values from the above table if the user enter 4 in the sheet 1 i need to count it and
if a second user comes a put data in sheet 1 it should increment sheet 2 need macro for it...

	Department A
	1	2	3	4
Q1				1
Q2				1
Q3				1
Q4				1
Q5				1
Q6				1
Q7				1
Q8				1

<colgroup><col style="width:48pt" span="5" width="64"> </colgroup><tbody>
</tbody>

 

[sijpie]

Where is the second Dept A employee's score recorded in Sheet 1? Do the columns extend to the right for each employee? Or is the score in the first column overwritten? In the last case, then how do you know this has happened?