Inventory and sales formula within a workbook.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Weaver Tom - 04 Sep 2007 16:44 GMT

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.

Signature

Most grateful for your assistance.

Reply to this Message

kassie - 04 Sep 2007 20:12 GMT

Hi Tom

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

Signature

Hth

Kassie Kasselman
Change xxx to hotmail

> 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.

Reply to this Message

Weaver Tom - 05 Sep 2007 04:32 GMT

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

Signature

Most grateful for your assistance.

> Hi Tom
>
[quoted text clipped - 7 lines]
> > results of the sales and have one sheet that would continually tally what the
> > sales are.

Reply to this Message

kassie - 05 Sep 2007 05:22 GMT

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?

Signature

Hth

Kassie Kasselman
Change xxx to hotmail

> Kassie-
>
[quoted text clipped - 19 lines]
> > > results of the sales and have one sheet that would continually tally what the
> > > sales are.

Reply to this Message