Dear all
I have sheet for overtime where daily overtime is recorded A1 has name , A2
has ID , c7:c30 has hours and c31 is total hours (this all is for 1 employee)
and exactly after 40 cells is for second employee i.e. A41 is name, a42 is id
, c47:c70 is hours and c71 is total hours for second employee.
now i want a summary of all this next page i want name, id , total hours

name, id , total hours
if i write a1, a2, c31 what will be the addresses in for next employee
is it a1+40 , a2+40 , c31+40 please help as i have lots of records
and i cannot go on searching manually and typing adresses i want to copy and
paste
regards and thanks