stock

  1. U

    Calculate/display age of stock

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

    Calculating days of supply using DAX...2

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

    Add Value's in a new row in a table with a button

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

    Ideas on how to track inventory expiration dates

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

    VBA code not working anymore?

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

    Have one cell check whenever data in another cell changes for entire column

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

    Copy pasting cells from one worksheet to another in Excel

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

    + and - (plus and minus) in Excel list

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

    Enter Timestamp for each time cell value changes

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

    Advanced: VBA - Click button on Website, copy output from CSV and Paste Contents to Excel

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

    Guidance: Data table setup for Dashboard (Pivot Charts) Output

    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 =...
  12. S

    Help with the formula for deducting raw material stock after sales of finished produt

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

    data entry form

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

    Automated Stock Sheet

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

    cell change on another sheet

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

    Multiple if statements to satisfy the requirement

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

    Formula using indirect

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

    VBA Delete Entire Row if Doesn't Contains Certain Text

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

    Automatically selecting the Display Area

    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)?
  20. R

    Require formula

    Hello, 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 <tbody> sales1 safety stock 1 56 2 5 3 1 4 9 5 1 Total numbers sales more than safety...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top