Inventory and sales formula within a workbook.

[Weaver Tom]

Good Day-
I am in need of creating a formula in my workbook of Excel 2002. I want to
have an inventory on one of the worksheets and on the other worksheet(s) have
a formula that will subtract or add inventory. I would like to see the
results of the sales and have one sheet that would continually tally what the
sales are.

 

[kassie]

Hi Tom

Not at all clear what you are trying to achieve here? Perhaps a more
specific explanation would help.

 

[Weaver Tom]

Kassie-

I am working on an excel spreadsheet. I have run into a problem of having to
make a formula go from one of the worksheets to another worksheet that is on
another tab in the workbook.
I understand that I can do formulas for this problem I am having; however I
need to know how.
Ex: on worksheet one I have an addition of 1+1. I can get the answer to go
to another one of the worksheets that I have.

Tom

 

[kassie]

If you have a formula doing a calculation on one sheet, which you also want
to show on another sheet, you have one of two options. Either enter the same
formula on the other sheet, or refer to the cell on the other sheet.

Say you have a formula in C1, such as =SUM(B:B), to total Col B in Sheet 1.
You want this total to also show up in Sheet 2, say in G25. In G25 on sheet
2 you can enter either of the following formulae

=Sheet1!C1, or else =SUM(Sheet1!B:B). Already having the calculation
formula in Sheet 1, I would use the first formula though. Hope this answers
your question?