need your help to get the function to get the data from sheet 2 to sheet 1.

[Giri.hb]

Hi Team,

I have attached the file, in that i have 6 sheets, each day there is a target of 30% to be achieve by each employee, when he achieved it he will get the 1 point on the C column. I will manually update the B column with the percentage the C column should be update with the points automatically(if he achieved 30% or more the point should be 1 if not it should be "0"). finally at the end of the week the week summary sheet should be update.

On week summary sheet the B column should be average total value of each day and the c column what I need is if the employee got the 3 or more points in the week it should be update as 1 point against that employee in c column, if its less than 3 points it should be "0".

Please advise and kindly do the needful and find the attached mail for your reference. Thanks for your help in advance.

Regards,
Girish

[Richard Buttrey]

Hi,

Please add the results you expect to see in the summary sheet.

Can I also suggest that you change your layout and keep all your daily data on one sheet. Add an extra column to record the date for each record so that you have 4 columns. Your analysis will be simplified considerably.

[tchock]

Hello Girish,

as Richard suggested, to achieve your desired result, it's better to organize your daily data in one sheet.
Please see attached my proposed solution.
Regards,
R

[samba_ravi]

see the attached file
one named range was created and used sumproduct, sum and indirect functions

[Giri.hb]

Hi Team,

Sorry I did a mistake, I have attached the new work book in that I have mentioned what I needed, I have more than 100 employees but I have given just an example in the spread sheet. I have updated everything on the day 1 sheet and same thing will repeat on all other sheet and also I have updated the weekly summary sheet manually but it should be automate. Please advise and let us know if you need further information. Kindly do the needful at the earliest. Thanks.

Regards,
Girish