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!
I am currently managing a minor inventory consisting of 101 unique goods. Currently my excel sheet looks like this:
To briefly explain the sheet...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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)?
Below is the simple data sales vs safety stock. I need 1 formula which calculates total number of sales more than safety stock. In this case it is 2
Total numbers sales more than safety...
Hope you can help with the below, I've attempted to google but I'm struggling to find results.
I'm trying to fill the total material used on the following two screenshots (there are about 40 total), the problem is if we require a SW 38x63 timber to be cut at for example 2m, the...
I have an excel sheet that help us calculate hove many days we have on stock for a specific component and return the date we run out of stock. The calculation contains the current stock level, different phase out day for for each product the specific component is a part of and usage per...