Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |