stock

Hi, Q1- I want to add the 5-month stock & calculate the average stock. |I used consolidate feature in sheet 7 but "Item Description" & "Whse" field does not come in the field. Kindly tell me how to do that with consolidate feature & different function or which one will be easy. I gather all...

I have the following formula below =IF(IFERROR(VLOOKUP(A5,'[Group Stock Report.xlsm]shirts'!$J:$J,COLUMNS(J:J),FALSE),VLOOKUP(A5,'[Group Stock Report.xlsm]Trousers'!$I:$I,COLUMNS(I:I),FALSE))="","Item in stock","item Sold") The ref number in the source file is in Col A Kindly amend my...

So I have a table with multiple columns, each representing a store. The rows are individual products while the value is the discrepancy of stock ie we are missing 5 stock (-5). Now I want some sort of tool that can calculate that if I’m missing 5 in one store, I can move 5 from another branch to...

Dear All Hi, As I am new to coding and after searching the internet for the solution and not finding it I am posting this here as I have been helped here before. I have a sheet of stock Outward, with the headers as: Column D=STM1; Column E=STM2 and on. In A column I have the stock items Range...

Hello can suggest me how would be a good way to allocate stocks to orders, and know, how much and what type of stock was assigned to each line row of the order Example Orders table <tbody> N_Order N_Item Qty_Asked 20001 10000001 100 20001 10000002 200 20002 10000001 50 20003 10000002...

Hi experts, I am really struggling with a formula for the following situation. I am trying to create a Job report on sheet 1 called "service order" On this service order i have created a table with the following information, Column 1 is (drop down)part type,column 2 is dependent on part...

Hello! I'm using solver for stock portfolio optimization. The solver changes weights to achieve maximum expected return. I have set the following constraints: The portfolio should consist of at least 5 stocks (out of 10) and maximum weight assigned for one stock is 30%. In this case the solver...

Hi Guys, I am having an issue which a spreadsheet where I have a list of stock <tbody> item SKU TYPE SIZE Starting QTY Running Qty Shirt SS-5XS SS 5XS 8 Shirt SS-3XS SS 3XS 23 Shirt LS-3XS LS 3XS 2 Shirt LS-2XS LS 2XS 25 </tbody> I then have a table which lists all items the...

Hi There, I have a bit of a dilemma with an excel sheet I'm working on and was hoping for a bit of advice from the experts on here. I am trying to create an excel workbook that can manage my inventory, record sales and stock purchases and display some figures in a nice little dashboard. Where...

If we have big database of daily stock prices with column of date,stock and price. How can we vlookup specific stock in specific date? On daily basis we have a large stocks list... Please solve this...

hi all. another day, another question from me - sorry.I have two very similar datasets, each on a separate worksheet in the same workbook. 'Dataset A' contains details of high priority/urgent orders (on a scale of 1 - 3: 1 = highest priority, 2 = high priority, 3 = urgent) placed by a single...

Hi All, Im trying to resolve below issue form a while. Currently im trying to build forecast vs stock calculations to show me weeks of cover. Im not looking for average but to calculate in Wk2 i have stock enough for ... weeks with the forecast value as .... Also include negative stock (to be...

<tbody> A B C 1 Sales Closing Stock 2 12/Dec 25 75 3 13/Dec 30 45 4 14/Dec 45 0 5 15/Dec 60 -160 6 7 Opening Stock 100 8 Runout ???? Needs to return 14/Dec </tbody> How do I get cell B8 to return the date 14/Dec as the date stock runs out? I have used IF formula but I am...

Hi All, I am trying to create a spreadsheet for a bar selling alcohol which has the GPP, VAT and cost prices for opening, closing stock and introduction of new stock. There is also an end-of-week stock check element This is the simple part. I had thought to run it for the whole year so it...

I am creating an Excel database of my 401k stock portfolio. I have the following tables (all formatted as Excel tables): /* All the different stocks that are available to invest. */ Funds (stock_symbol, fund_name, fund_description) /* Prices for each fund for every date since start of...

In the course of learning to scrap data from URL, I have been using Web Query function. However, when I try to get stock option data from this site https://www.hkex.com.hk/eng/stat/dmstat/dayrpt/dqe181123.htm , I end up only getting the header and not the content. In particular , I would like...

On sheet1 I have product lists along with all the details and unique barcode. On sheet1 "barcode" column is "A" and "stock quantity" column is "E". On sheet2 "barcode" column will be "A" for scanning the barcodes and available "stock quantity" column will be "B". what I want is whenever I...

Hello! I would like to ask you for help programming inventory management system in excel using VBA and userform. I would like to form one easy excell file, which gives you information about stock level (I am starting with small business for parents and my 2 parents besides me will pack...

I would like to retrieve the Option Price last quote from Yahoo. Writing a vba code to retrieve this information from a website is far beyond my novice abilities, so I would like the kindly request from the VBA community if you could offer a vba code that would accomplish this task. The url...

Hi all, First time posting. I am trying to get a button to add incoming stock into a stock on hand column as well as a usage button to subtract stock from the same column. I have attached an image with the spreadsheet as well as the code for the macro (which I have borrowed from one of the...