stock control

I am currently trying to construct a table of raw materials that will automatically adjust based on information entered about productions. The system currently consists of 3 excel sheets: 1. A general ledge of all finished product stock in and out. This consists of columns for date, product...

Hi, I am new to VBA and need some help. I have a user form designed to enter: Stock code Price Qty Postage cost I have it set up so that when you enter: Stock code - value goes to sheet (sales) and enters the value into next empty cell column a price - column b qty - column d postage cost -...

Hi Everybody. I'm in a bit of a pickle and i'm hoping someone can help me. The current situation: Our stock dispatcher in the past has been using a spreadsheet that only he understands and even then, the convoluted ways he goes about tracking stock quantities and locations means he doesn't...

Hi everyone, I am looking for some help for creating an inventory database. Basically what I want to achieve is: - when bringing new items in the inventory: I will print barcode stickers and stick them on each new item brought in (on every item different barcode even if items are the same)...

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

Hi there, I am a newbie on the site. I have a question for the clever people... Is it possible in Excel to create a stock control sheet pulling the info from an invoice also created in Excel. ie I have the initial stock in excel sheet, when an item is sold, it updates the stock sheet from the...