formula for copying from one sheet to another

P

Pakmount

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
 
D

Don Guillett

put the info in the same cell on each sheet then
=sum(yourfirstsheet:yourlastsheet!a2)
 
P

Pakmount

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!
 
D

Don Guillett

then you should do all of them on the same sheet and use autofilter to
isolate.
 
Top