formula for copying from one sheet to another
 

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

formula for copying from one sheet to another
 

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

--
Don Guillett
SalesAid Software

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

formula for copying from one sheet to another
 

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!


"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

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

formula for copying from one sheet to another
 

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

--
Don Guillett
SalesAid Software

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


"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

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