stock

  1. 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...
  2. 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 =...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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)?
  11. 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...
  12. Y

    Lookup different multiple criteria and multiple results

    Hi MrExcel, 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...
  13. K

    Calculate end of stock date with NPER formular

    Hi all, 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...
  14. R

    double sort and percentrank function with NA in VBA

    Hello guys, My data set is like this: <tbody> Stock Return Criteria1 Criteria2 Percentrank.INC 1 0.1 W 0.9 2 0.3 M 0.7 3 0.2 NA 0.3 4 0.1 L 0.5 5 0.5 M 0.33 6 0.2 W 0.88 7 0.1 W NA 8 0.4 L 0.2 9 0.2 L 0.77 </tbody> What I want to do is to run double sorts in VBA...
  15. R

    'Percentrank' function under double sorts with 'NA's

    Hello guys, I have 2 columns, the first one (we say A1:A100) contains 'W's, 'M's, 'L's, and some 'NA's, the second column (B1:B100) contains figures (stock returns) and also some 'NA's. what I want to do is to calculate the percent rank for each stock under 'W' group, 'M' group, and 'L' group...
  16. P

    Daily inventory follow up - opening stock = to closing stock previous day if....

    Hi, I have a simple worksheet with daily stock entry and withdrawal for different items (based on a validation list). Column A = product description (items from the validation data list) Column B = Opening stock Column C = Withdrawal stock Column D = Closing stock I want to find...
  17. S

    Is it possible to create a VBA code that would recognize phrases out of context ?

    So far I know how to extract certain words and potentially even match it into phrases without using VBA, but it is very crippled. But is it possible to teach/have VBA recognize the phrases out of text. Example: we need to recognize when paper was not in stock I went to store and did not...
  18. S

    userform list view with multiple filters

    Hi all, I hope that what I’m about to ask doesn’t seem too difficult to picture, but I’ll try to put it out as plainly as I can for you to see what I’m getting at. I run a Stock Control workbook containing a very large dataset spread over about 20+ worksheets – let’s call it “Stock KPIs –...
  19. C

    Stock Control

    Hi Guys I have a limited knowledge of excel, but unfortunately I have been volunteered to implement the below: I want to able to do the following: 1. scan a product in that it registers in excel 2. then scan it into the stock location area 3. then scan the quantities , I presume we have...
  20. P

    Max If formula - where am I going wrong

    Hi, Not sure where I've gone wrong and this should be a fairly simple one hopefully. I have dates despatched in one column and time in stock in another. I wish to make a graph to show (hopefully) a quicker stock turnover as time goes by. I have the following, where Sheet1!A contains dates...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top