formula for copying from one sheet to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I information that has been entered into one sheet, to automatically copy to
another sheet when it is updated. I am taking time card information from 10
sheets, and want to combine them into one summary sheet automatically. I
could really use some help! Thanks
 
put the info in the same cell on each sheet then
=sum(yourfirstsheet:yourlastsheet!a2)
 
maybe i didnt word what i was trying to do properly. I dont need it to
"sum", i need it to copy the entire worksheet to a range of cells on my
"Totals" Page. So that each employee (they each have a seperate worksheet),
is listed on one page with each day, hours worked, cost codes etc. Thanks for
your help!
 
Back
Top