inventory control

Hi, I don't know if I can make sense of this, but I work with inventory have a need to use excel to increase decrease inventory based on sales and restock. It'll be great if I could get some help with this. Lets say that I house 100 different items with their own unique sku/upc in stock and 50...

ok, this is the issue, i work normally with 3 or 4 different worksheets of inventory, one of the company that i work for, a shelter company, the one from customs and from the warehouse and i have to compare them, match them, know if they have different quantities or values and have all the...

I am trying to manage an inventory list and running into trouble getting the current inventory to automatically update in the same cell. Currently, I am trying to figure out a way to store the result of a formula in another cell as a value. This cell will be used as part of the original formula...

I need to create an Ageing report for the inventory at hand. The issuing of inventory uses First In First Out (FIFO) principle.Hence If I receive 10 qty in period 3 (say 60 - 90 days) and issue 2 the answer would be 8 remaining. Now if I receive 5 in Period 2 (30 - 60 days) and issue 3, the...

<ins style="display:inline-table;border:none;height:60px;margin:0;padding:0;position:relative;visibility:visible;width:234px;background-color:transparent"><ins id="aswift_0_anchor"...

I have a WORKBOOK named "Inventory". It consists of several WORKSHEETS that divide my food inventory into categories such as "MEAT", "DAIRY PRODUCTS", etc. I recorded a macro that will import my inventory from an online ordering system, dump it to a WORKSHEET named "IMPORT" and normalize the...

I will admit I am not a excel savvy person, so I could really use some help. Currently all of my inventory is saved to an excel 2010 spreadsheet, about 162 items. Each item has an ID number & description. Also on the spreadsheet are the quantities in my 2 locations and lastly the unit of measure...

For Inventory, manufacturers barcodes are being imported or scanned into Excel, problem is that Euro barcodes bring in sometimes "=" as a prefix to the numerical value skewing what Excel reads, converting the number sequence into a "formula". I want to understand and convey to Excel that it is...

Hi, I'm totally new on excel and on this forum. But I would try to be the most specific as I can. I use to have a small store where I could keep record with a normal simple excel sheet. But it has come to a point where i think i have to create macros or program with VB. My problem is I have...