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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy from one sheet to another 3
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
Copy Data from 1 Sheet to Another 3
Formula Based on Multiple Sheets 5
Referencing formula using Indirect 4
formulas copying from sheet to sheet 6
Copying cells from one sheet to another 5
Count the columns from one sheet and paste it in another sheet 0

Back
Top