inventory database

  1. R

    import out of stock item to another sheet

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

    Need Help with creating a pop up window for an inventory system- VBA

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

    Running inventory with date criteria

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

    Data validation for inventory warning

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

    Inventory Mgmt Buttons - VBA code showing no errors but not working as intended

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

    Managing internal/ external inventory tables

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

    inventory report showing the ending balance of the previous month as the beginning balance of the current month

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

    Excel 07 - Barcode Scanning with auto entry of current date and a constant number - Please Help

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

    Inventory Control

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

    Inventory PAR Levels

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

    Using Access as Backend and Excel as Frontend

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

    Using Access as Backend and Excel as Frontend

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

    Excel Formula Qn for Inventory

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

    Inventory Manage

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

    Email notifciation for an IF Function

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

    Supply Request UserForm to Update Supply Inventory

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top