stock

Hi everyone, this is my first post, so apologies if I make any mistake in posting here. I have been browsing through the forum and found some similar threads but none that really matched my problematic. I am currently managing the stock and dispatches for the company I work for. In my...

Hi all! Hope somebody can help me with this, see attached snap. I want to calculate how old the daily stock is. What I want in the line 'age of stock' is the total kilograms which are obsolete. In this example the product expires in 3 days, so consider what will be older than 3 days have to be...

Hi all Regard to Calculating days of supply using DAX... thread I would like to ask you for help. I need to calculate Days of Cover. Data structure is following: WeekDate, Product, ClosingStock, Demand. I tried to use the code from previous thread but I hit on problems. First one is on the line...

Hey! I am working on a stockmanagement system in Excel. I worked out most of it but to make it as easy to manage as possible i would like to work out the following: I want to put value in certain cells on the top of the sheet. With 3 different buttons you can put these at the end of 3...

NOTE* Please skip until the next line highlighted in bold if you're not interested in seeing how my setup functions. Thank you! Hello everybody, I am currently managing a minor inventory consisting of 101 unique goods. Currently my excel sheet looks like this: To briefly explain the sheet...

Hello everybody, I am currently managing a stock tracking file, which is edited manually to a large extent. Currently, the four significant columns look like this: Here, column I is the actual quantity in stock. If my code was functioning, which it was as of yesterday (and I have made no...

Hello everybody, I am currently managing a database full of stock quantities, here: Is there any way (I imagine some VBA coding) in which I can create a column 3 rows to the right of this one (row L in this case), where every single cell in row L would count the last time (in date, so for...

Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...

Hello everybody, I am currently currently managing a stock overview in Excel (manually), where I have a set quantity. I want to create two columns next to my quantity column where I can enter numbers that should be substracted and added to the quantity, so it looks like this: Now obviously I...

I have dynamic low of day (LOD) stock prices in column A and last stock prices (LSP) in column B. The data is pulled from an external web service and never hard coded. I need to create 11 additional columns of data based on these two values: Column C would display the times the LSP fell below...

I am a novice in vba and am starting to learn a few things, but i'm stumped on how to do the following: Essentially, I have a workbook that contains a list of stocks (range a8 to a200) on a worksheet called "summary". Each stock in the list has its own worksheet and I want to download financial...

Hi, Looking for guidance to create a Dashboard for quanties of stock, cashflow and other KPIs. I have table of data where: Column A = Date (ordered, earliest to latest) Column B = "In" or "Out" (if it's stock received or stock dispatched) Column C = Product code (e.g. 1, 2, 3, 4, 5) Column D =...

Need to deduct raw material quantity once the sale is happened for finished good. Example a cake of 1 kg will have different ingredients like sugar 20gm, baking powder 20gm, etc. So if I sell 1 kg cake automatically the ingredient should be deducted from stock. So if I have sugar say 100gm in...

I have looked in google and not found the answer to this question. 2 actually First is it possible to edit which fields appear in the data entry stock form. I do not want all of the columns to show up in it. I have formulas in some of them that will calculate based upon the what data is...

Hi, I’m trying to find a solution to automate a stock sheet. I have a register of various sizes based on diameter and length on one tab. On other tabs I’m trying to look at the first tab and automatically add new items or down date quantities you can see on the used / create tab, it has two...

Hi, I have a workbook with numerous worksheets ranging from 1 - 30. Sheet 1 contains stock levels for each item within column K Staff enter info on the specific client sheets (sheet 2 - 30) which then deducts the stock ordered from sheet 1. (ie so if a client on sheet 3 orders 10 units of an...

Hello Experts, I need your help to automate a long manual activity which takes allot of time. Every week I have received stock transfer requests of 500 line items from LHR and ISB to replenish the stock from KHI which is our central Warehouse to feed both locations. Please see below table with...

Hi all, I need a little bit of a help to make a formula... I might have two lines with the same component in a big list, and I want my stock figure to be updated in the second line based on previous calculation. I tried to use indirect and ROW()-1, but had no luck. So, I have a available...

Hi guys, Any idea of a quick macro that will help me, I would like to delete all rows that doesn't contains at least IN, CH, EL on column A I do have many items in my stock list and I would like to keep all parts # that start by IN, CH and EL and delete all the rest that doesn't contains those...

I have a long list of stock option strikes, 130 in all. When the stock price moves up or down beyond the number of rows I can see in my display, is there a way to automatically center the display based on a specific cell (at-the-money strike)?