Excel & Inventory
 

Hi,

I want to use Excel as inventory software! Is there any templates that I can
download or any suggestions from where I can begin?

Thanks in advance

Excel & Inventory
 

Go to the Office Template Gallery and type "inventory" in the search dialog.

http://officeupdate.microsoft.com/te...ry/default.asp


Gord Dibben MS Excel MVP

On Tue, 4 Dec 2007 00:16:40 +0100, "eman" wrote:

Hi,

I want to use Excel as inventory software! Is there any templates that I can
download or any suggestions from where I can begin?

Thanks in advance

Excel & Inventory
 

Thanks for the reply.

In the mean time what I'm trying to do is this:

(Please find attached Study1 file)

Example If I write 2 in G4 it writes the profit of two in H4 that is $20.
Now what I want is that when I write 2 in G4 I want that the QTY stock (C4)
turns to 2 and cost stock (B4) turns to $100 in the same time. I mean in 1
click!

Is it possible?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Go to the Office Template Gallery and type "inventory" in the search
dialog.

http://officeupdate.microsoft.com/te...ry/default.asp


Gord Dibben MS Excel MVP

On Tue, 4 Dec 2007 00:16:40 +0100, "eman" wrote:

Hi,

I want to use Excel as inventory software! Is there any templates that I
can
download or any suggestions from where I can begin?

Thanks in advance

Excel & Inventory
 

Attached files are frowned upon in these news groups and most likely won't get
any takers for opening.

Secondly, I am not running Excel 2007 and don't feel inclined to download a
compatibility pack to open your workbook in 2003.

From your description it looks like you need a few formulas.

Where is the unit price located that would be multiplied by 2 in H4 to return
$20?

Where does the QTY(stock) in C4 come from? Manually entered or derived from a
formula?

Why should B4 change to $100 when you enter a 2 in G4?


Gord

On Tue, 4 Dec 2007 01:01:49 +0100, "eman" wrote:

Thanks for the reply.

In the mean time what I'm trying to do is this:

(Please find attached Study1 file)

Example If I write 2 in G4 it writes the profit of two in H4 that is $20.
Now what I want is that when I write 2 in G4 I want that the QTY stock (C4)
turns to 2 and cost stock (B4) turns to $100 in the same time. I mean in 1
click!

Is it possible?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Go to the Office Template Gallery and type "inventory" in the search
dialog.

http://officeupdate.microsoft.com/te...ry/default.asp


Gord Dibben MS Excel MVP

On Tue, 4 Dec 2007 00:16:40 +0100, "eman" wrote:

Hi,

I want to use Excel as inventory software! Is there any templates that I
can
download or any suggestions from where I can begin?

Thanks in advance

Excel & Inventory
 

Unit price is located in D4.

QTY(stock) in C4 is manually entered

In B4 I have cost of all 4 items that is 200 SO when 2 are sold then the qty
turns to 2 and cost turns to 100.

This is exactly what I have:

B4 (COST OF 4 ITEMS) $200
C4 (QTY) 4
D4 (COST OF 1 ITEM) $50
E4 (RETAIL PRICE OF 1 ITEM) $60
F4 (PPROFIT OF 1 ITEM) $10
G4 (QTY OF ITEMS SOLD) 0
H4 (TOTAL PROFIT) 0

What I am looking for is: that when I write 1 in G4 (meaning 1 item is sold)
then B4 turns to $150, C4 turns to 3,
and H4 turns to $10.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Attached files are frowned upon in these news groups and most likely won't
get
any takers for opening.

Secondly, I am not running Excel 2007 and don't feel inclined to download
a
compatibility pack to open your workbook in 2003.

From your description it looks like you need a few formulas.

Where is the unit price located that would be multiplied by 2 in H4 to
return
$20?

Where does the QTY(stock) in C4 come from? Manually entered or derived
from a
formula?

Why should B4 change to $100 when you enter a 2 in G4?


Gord

On Tue, 4 Dec 2007 01:01:49 +0100, "eman" wrote:

Thanks for the reply.

In the mean time what I'm trying to do is this:

(Please find attached Study1 file)

Example If I write 2 in G4 it writes the profit of two in H4 that is $20.
Now what I want is that when I write 2 in G4 I want that the QTY stock
(C4)
turns to 2 and cost stock (B4) turns to $100 in the same time. I mean in 1
click!

Is it possible?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
Go to the Office Template Gallery and type "inventory" in the search
dialog.

http://officeupdate.microsoft.com/te...ry/default.asp


Gord Dibben MS Excel MVP

On Tue, 4 Dec 2007 00:16:40 +0100, "eman" wrote:

Hi,

I want to use Excel as inventory software! Is there any templates that I
can
download or any suggestions from where I can begin?

Thanks in advance

Excel & Inventory
 

You can't (with a simple formula) achieve what you've asked for. You are
trying to use C4 as a cell in which to insert the initial quantity, but then
use the same cell to display the quantity remaining. A cell can contain a
number or a formula, but not both. You'd be better putting your initial
quantity in one column, and calculating the number remaining in another
column. Then the job would be easy.
--
David Biddulph

"eman" wrote in message
...
Unit price is located in D4.

QTY(stock) in C4 is manually entered

In B4 I have cost of all 4 items that is 200 SO when 2 are sold then the
qty turns to 2 and cost turns to 100.

This is exactly what I have:

B4 (COST OF 4 ITEMS) $200
C4 (QTY) 4
D4 (COST OF 1 ITEM) $50
E4 (RETAIL PRICE OF 1 ITEM) $60
F4 (PPROFIT OF 1 ITEM) $10
G4 (QTY OF ITEMS SOLD) 0
H4 (TOTAL PROFIT) 0

What I am looking for is: that when I write 1 in G4 (meaning 1 item is
sold) then B4 turns to $150, C4 turns to 3,
and H4 turns to $10.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Attached files are frowned upon in these news groups and most likely
won't get
any takers for opening.

Secondly, I am not running Excel 2007 and don't feel inclined to download
a
compatibility pack to open your workbook in 2003.

From your description it looks like you need a few formulas.

Where is the unit price located that would be multiplied by 2 in H4 to
return
$20?

Where does the QTY(stock) in C4 come from? Manually entered or derived
from a
formula?

Why should B4 change to $100 when you enter a 2 in G4?


Gord

On Tue, 4 Dec 2007 01:01:49 +0100, "eman" wrote:

Thanks for the reply.

In the mean time what I'm trying to do is this:

(Please find attached Study1 file)

Example If I write 2 in G4 it writes the profit of two in H4 that is $20.
Now what I want is that when I write 2 in G4 I want that the QTY stock
(C4)
turns to 2 and cost stock (B4) turns to $100 in the same time. I mean in
1
click!

Is it possible?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Go to the Office Template Gallery and type "inventory" in the search
dialog.

http://officeupdate.microsoft.com/te...ry/default.asp


Gord Dibben MS Excel MVP

On Tue, 4 Dec 2007 00:16:40 +0100, "eman" wrote:

Hi,

I want to use Excel as inventory software! Is there any templates that
I
can
download or any suggestions from where I can begin?

Thanks in advance