inventory management

Dear All, I have a small apparel business setup from home. I want to automate the workbook so as to cut the time of recounting the products and calculations. I have two sheets the first contains my stocks and second Clients orders. I want to automate in Allocation Column where I want a...

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

Hello Verse, I have been recently instated as the inventory management person while we are trying to digitize our daily checklist. I have more then a few asks. First up is going to be: Can I use the conditional formatting that already exists within the workbook as a reference to pull that...

Hello Members, Thanks for being here and hopefully it will be my playground, I have come across a tutorial in Youtube for Inventory Manager. Front End Excel and backend VB. Just the time I attacked VB, An Error messege popped out on Running macro. The error is as follows: Run-time error...

Hi I found this tutorial very https://www.mrexcel.com/excel-tips/how-many-kits-available/ helpful. It has solved my issue to some extent. I am trying to create a stock and inventory management sheet. We sell one main kit and then an add on kit which comes in 8 different types. There are a few...

I am trying to develop a macro in VBA to manage loaner vehicles for an automotive service department (see sample below). This is what I have put together so far, obviously it doesn't work: Sub Duplicate_Entries_Based_on_Return_Date() Dim lastrow As Long 'Find the Last Row...

I am trying to analyze our company's sales data to better understand which items frequently sell together so that we can better organize our inventory and cut down on time to assemble orders. The data is organized by order number and product number. My initial thought was to take the top...

Hello, I am wondering if someone could help me with some suggestions on inventory sheet that I have. Currently, this sheet is distributed to our customers and lets them know if a product is In stock/Out of Stock/Low Stock or Very Low stock. Also, this sheet provides a Available date...

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 everyone, Thank you all in advance for your assistance. Background: I work for a construction company and am trying to make a workbook that I can use to track the expenses incurred, deliveries received and revenues produced on a day to day basis. My goals. 1. (1) master work sheet that i...

I am looking to use Excel as an inventory management tool. I have about 100 items that I need to track. Anybody using anything creative in Excel to accomplish this? I want to keep track of physical counts (done 2-3 times per week), usage (how many to where on what date), and orders coming in...

I am trying to manage a list of inventory items using Excel 2016. I have three end products, each with its own Bill of Materials, and I have the relevant information all on one worksheet (Inventory Part, current inventory quantity, and quantity of said part in each of the 3 BOMs). Say I am...

Hello, I am trying to create a function in MS Excel that will find the average cost per unit using the FIFO costing method based on the units in inventory and a purchase ledger (quantity, price, total etc.). If a purchase is marked as contract I would NOT like it included in the average cost...

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 have multiple products with days until next shipment, inventory, and the start of a formula but I'm stuck. I don't know what to do to subtract the outbound inventory from a FIFO standpoint and keep my days in inventory calculation correct. To best summarize where I'm at I have written some...