inventory database

Looking for a IF/Then formula to add to my spreadsheet. The inventory removal will be done manually but I would like it to have a cascade effect from cases into 6 packs into individual. On the sheet I have 24 individual bottles of heineken being removed. I only have 15 individuals in the...

Hi. what i have here is a little inventory system and its working with barcode. in the OUT sheet all out of stock is automatically marked red. im thinking is there a way that i can import all (0) or out of stock products to a different sheet and automatically remove when Stocked, so that i can...

I am trying to create an inventory based database for our online orders. There are 10 different bundles that consist of multiple products that can also be shipped individually if not apart of a bundle. What I want to be able to do is create a day by day process where a window pops up asking what...

I have 2 sheets: one with Inventory for a day (8/30) and another with sales for the month with dates as 9/4, 9/7. etc. I would like to merge the two sheets so I can have a running total of inventory by taking the Inventory as of 8/30 and subtracting each day of sale invoices. I would then...

Hi, Im trying to create an inventory sheet in excel 2007 and i want a warning message to pop up if cell B29 total is less than 26. I have an auto sum set up already in cell B29 so when it did not work the first time i thought maybe because i cant have 2 formuals in one cell but i also typed 26...

Hello and thank you for taking a look at my Excel VBA inquiry! I am working on creating an inventory management system using Excel and VBA code for several buttons. For a bit of background information, our company manufactures vacuum tube audio amplifiers and keeps hundreds of components in...

Hi, I have a master table used for internal inventory management. I would like to periodically create a table with only SOME of the data to be published to customers (I'm fine with creating it manually at the moment). The master table holds both columns and rows that I would like to omit in...

I am in the process of making an inventory report using a pivot table. However, I have this problem of displaying the ending balance of the previous month as the beginning balance of the current month. Please help me solve this problem. Here are the column fields of my data source: year, month...

Hi - I am looking to create a record log in Excel 07 by scanning in various barcodes with one of the scans triggering an auto entry of current date in column A and a constant data in column F. Seven columns total with indefinite amount of rows. My current setup: I can scan six columns with...

I have to create a speadsheet that tells me how much of 1 item was used by spesific members using the following information Column A (item bin nr) Column B (description) Column C (member) Column D (quantity of item used in 1 of many orders) Colunm E - H (dates and internal order nrs) What...

I am working on inventory PAR level project. I have data from the last 3 months and need to determine what the PAR levels should be to ensure that there is never shortage or an overstocking issue. I have the data from all 3 months on one worksheet but want to be able to place on another...

I am making an inventory system for a consultant who buys products and sells them at vendor shows. I have a simple table in Access that holds the quantity of each item the consultant has. I would like to be able to use Excel as a front-end interface for manipulating this data (through...

I am making an inventory system for a consultant who buys products and sells them at vendor shows. I have a simple table in Access that holds the quantity of each item the consultant has. I would like to be able to use Excel as a front-end interface for manipulating this data (through...

Hi, I've been stumped trying to figure the formula for the following problem. Any help is appreciated. I am creating a financial spreadsheet using Excel for Mac 2011 (v14.3.8) with the following rows (the columns are months of the year):- Row 1: Pre-sales Inventory Row 2: Total units ordered...

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

Hi, I'm fairly new at working with Microsoft Excel and all its complicated functions (given my restricted knowledge). I'll try not to make the post too long but I'll try and give enough information. Currently I'm working on an inventory database where the operators in my team can log in how...

Hello, I am creating a userform for employees to request office supplies. Their requests creates one database so we can see how many supplies are being used, and which departments have the greatest needs. I have another database of the supply inventory that I would like to be instantly...