Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel inventory spreadsheet | New Users to Excel | |||
Excel used for inventory control | Excel Discussion (Misc queries) | |||
How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
inventory in excel | Excel Worksheet Functions | |||
Excel games inventory | Excel Discussion (Misc queries) |