Need Help with carrying totals forward PLEASE!!!

P

Piano_Man

upon creating my first spreadsheet, for inventory purposes..........is there
a way to carry totals from one spreadsheet forward to a new spreadsheet
using the same excel Spreadsheet template?

For example:

Inventory
Start total End Total Used
5 3 2
3 1 2


Total used: 4

Then on the next sheet I would like the end Totals to carry over to the
template spreadsheet
with the end Totals becoming the new sheets Start totals!

I hope this isnt too confusing, but I just want to be able to carry over
totals from one spreadsheet (using a template) to another!

Thanks for your help SO SO SO Much!

regards

Martam Allen

(e-mail address removed)
 
L

Lady Layla

Have the start total cell refernce the end total in the previous sheet.
In cell for start total #1, enter +(then click on cell with ending total for
prior month), then hit enter


: upon creating my first spreadsheet, for inventory purposes..........is there
: a way to carry totals from one spreadsheet forward to a new spreadsheet
: using the same excel Spreadsheet template?
:
: For example:
:
: Inventory
: Start total End Total Used
: 5 3 2
: 3 1 2
:
:
: Total used: 4
:
: Then on the next sheet I would like the end Totals to carry over to the
: template spreadsheet
: with the end Totals becoming the new sheets Start totals!
:
: I hope this isnt too confusing, but I just want to be able to carry over
: totals from one spreadsheet (using a template) to another!
:
: Thanks for your help SO SO SO Much!
:
: regards
:
: Martam Allen
:
: (e-mail address removed)
:
:
 

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