have value in A1 & want value after 20 cells is it =a1+20 ????
 

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

A1: =INDIRECT("A"&(ROW()-1)*40+1)
B1: =INDIRECT("A"&(ROW()-1)*40+2)
C1: =INDIRECT("CO"&(ROW()-1)*40+31)

and copy down
--

HTH

RP
(remove nothere from the email address if mailing direct)


"masrat" wrote in message
...
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