Smurfit-Stone
Active Member
- Joined
- Dec 1, 2004
- Messages
- 485
Hello Board,
I need a formula or macro that will take totals from one worksheet that are linked to another worksheet (=Tickets!E42). The worksheet Tickets is fill in for every shift. Each shift clears the previous data and enters new data. What I want is the worksheet "Totals" to keep the previous total and add the next shifts totals. So that if the 1st shift has a total of 298, when the form is cleared to entry of the 2nd shift data, the Totals worksheet will keep the 298 and add whatever is the total for the 2nd and 3rd shifts. Is there a way to do this without creating 3 separate forms? Thanks in advance.
I need a formula or macro that will take totals from one worksheet that are linked to another worksheet (=Tickets!E42). The worksheet Tickets is fill in for every shift. Each shift clears the previous data and enters new data. What I want is the worksheet "Totals" to keep the previous total and add the next shifts totals. So that if the 1st shift has a total of 298, when the form is cleared to entry of the 2nd shift data, the Totals worksheet will keep the 298 and add whatever is the total for the 2nd and 3rd shifts. Is there a way to do this without creating 3 separate forms? Thanks in advance.
