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!
 
then you should do all of them on the same sheet and use autofilter to
isolate.
 
You must log in or register to reply here.

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