How do I get totals to carry over to the next wooksheet in a work book?

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

Guest

I have construction time sheets on excel. every day is one worksheet, and has a total for that day in a certain cell. once i get a total in day one i want to copy it to a new tab (worksheet) called day two, that sheet will have a total for the day and i also want it to look back and get the total from day one and put it in a cell below day twos totals. this i can do. where i have a problem is if i try to copy day 2 and move or copy it to a new shhet called day three, it still wants to look back at day one. how can i get the total cells to automaticly change and only look back to the previous worksheet. Please help me. Thank you.
 
the only way I can to accomplish this is probaly more difficult tha
simply changing the referencein the cell, but here goes

in a cell write DAY, in another cell put the number of the day you wan
like 3 for example, in another cell put what cell that data is in wit
the ! in front of it like !A1

then use the CONCATENATE function to put it all together in to th
refrence for that cell on the write page.

then in the cell where you want to display the data put =INDIRECT(th
cell with complete refrence in it)

that will work each time you paste this to a new tab you only nee
change the cell with the day numbe
 
Back
Top