inventory control

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

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

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

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

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

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

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

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

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

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

Can anybody share me a Excel Work Sheet for Grocery Shop Complete Inventory Control

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

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

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

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

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

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

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

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

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