inventory control

  1. B

    VBA for Generating Cycle Counts

    I am looking for a VBA assigned to a button that will generate a cycle count for inventory control purposes. Each time I press the button, a new list will populate and not repeat any part numbers from a previous time of pressing the button. The list of part numbers with description/ location are...
  2. B

    Inventory and cost management

    Hi, I was hoping someone could help me with an excel problem I have. I run a business and have a purchase list on one tab with all the products I have purchased, the quantity purchased and cost each time they are purchased. I then have a sales list tab which records the sales price, any fees...
  3. R

    comparing array - finding how many kits can be made from existing inventory

    Hi all, I have inventory stock details with 11,000 part count and I am making vehicle from this inventory. Now for one vehicle I require 1300 to 1500 parts with varying quantity on each part. there will be multiple vehicle codes I want to create a crisp VBA where it will show me 1) how many...
  4. Nikkolas Camp

    Custom Barcode Inventory System Using Excel

    So, I'm wanting to build a custom inventory spreadsheet to better track out material in house. We have a process to tracking our inventory, it being tracked in total square yards. We currently do our inventory the old fashion way, that being with our trusty pencil and paper, read all tags...
  5. 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...
  6. X

    How to use index match to calculate inventory transfer

    Hi there, I would like to create a formula in column I to calculate which branch can transfer out stocks to those fast moving branches within same country. Refer to below table: Branch code 2002 (in Malaysia), my stock on hand is 1 pc, sales per month is 6 pcs, I have to transfer in about 5...
  7. C

    Inventory Comparison: 2 Sheets sent to 1

    Hi. I am running into an issue where I need to compare 2 worksheets for inventory changes and product differences. Every formula I have tried has erred on me and I am hoping someone can help as I have been at this for several months. I am visually blind so comparing over 10k lines manually on...
  8. 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...
  9. A

    Formula needed, Projected sell out date

    I'm trying to find a formula to calculate the projected sell out date of our inventory, example if i have 1582 of one item in stock, and sell 181 a month, when will I sell out? Below is a list of our order, hence why ((D2+F2)/K2) was my first thought, but I am not sure how to make it project a...
  10. C

    Excel Manufacturing inventory

    Recently got promoted at my job to start and manage inventory. We have a set up excel sheet but currently have to manually update inventory when a product leaves. To keep it short for example product one uses 5 screws, 2 nuts, and one hinge. How would I make it so that if I enter that we sold 5...
  11. M

    Inventory

    I'm trying to create a spreadsheet to keep track of my inventory.I am using Microsoft Excel for mac on 365Column I, I would like to add new stock in to add to Column K which I can do by a formula using column J<tbody>=I+J</tbody>Ideally, I want a macro button or something that then deletes I for...
  12. M

    Excel Work Sheet for Shop Complete Inventory Control

    Can anybody share me a Excel Work Sheet for Grocery Shop Complete Inventory Control
  13. 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...
  14. J

    Split Date Formula

    Hello, I constantly work with product inventory and I would like to know how to split dates based on time periods (Calendar Years or Time Periods i.e. 4/1/16 - 3/31/17 or 10/1/16 - 9/30/17. Is there a formula I can use for this... For Example I have the following product with time period...
  15. S

    Creating inventory with excel

    We have a warehouse, we buy a bunch of foodtruck items..big and small items. I been told to start an inventory of the items and i know enough to seek help with excel. Can excel help me? Doesn't matter if its a simple layout, I have a laser barcode scanner, and thats about it. Not sure how to...
  16. J

    stock button macro

    hi, im totally new to excel, never worked with it but i need it now for stock reasons i was looking at this video.(video link below) to see how to create those buttons where you put the in's and out's for the stock with button to refresh the cells below, i need help with it what would the macro...
  17. B

    Pivot Table Problem

    I'm trying to get a 52 week sales/inventory report to auto fill from a data dump in the form of a pivot table. The only problem is that if there is no sales data from a week then that week does not show up in my pivot table because of the lack of source data. For example if there were no sales...
  18. M

    Inventory Management using Barcode Scanner

    Hello, I am looking for some code that would allow me to use a bar-code scanner to create a simple inventory. I work in an office with a high degree of check-in/check-out activity for inventory, and being able to simply scan items in/out would be a big help. Consolidating that data has been...
  19. P

    How to format spreadsheet to accommodate 1 item with multiple buyers

    Hello and Thank-you all for looking at my question. I’m not sure how to word my question to get a proper answer. I want to do some inventory “control” I have a spreadsheet made out and have a formula that deducts everytime an item is sold. My problem is, how do I deduct with multiple buyers...
  20. H

    Tracking Equipment, Room to Room

    Im trying to establish a system where different pages on excel are representing different rooms and the data is scannable bar codes representing equipment moving from room to room. Ive got CONCATENATE under control but I don't understand how to make a piece of equipment on Room A's list disapeer...

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
Back
Top