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
|