Keeping Running Totals?

M

mcr1

OK. Thanks for the help in advance. I have a elaborate spreadshee
that I have created and it totals flight times and things like that.
Each time I fly, I update the sheet with new times. Each time I hav
to go in and put the old flight times on the new sheet so I can add th
new flight times to the previous totals. I am wanting a way to ge
excel to automatically transfer the totals from the previous flights t
a new sheet everytime I fly and want to update the total times. I a
wanting to eliminate the step of having ot go in each time to the ne
sheet and add the previous flight's totals. For example, the airplan
has 100 hours of flight time on it. On Monday, I fly it for 5 hour
and update the spreadsheet I created. Now, on Tuesday, I fly for
hour. I want to be able to open my Excel spreadsheet, and not have t
put that the aircraft has 105 hours on it. I want to be able to ope
the sheet and it already knows from getting the info on the previou
sheet that the plane has 105 hours on it and i just have to add th
days (1 hour) flight to the new sheet, and when I close it or whatever
I want to be able to open it the next time and it once again knows th
place has 106 hours on it now, and so on and so on
 

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

Top