stock

Hello Everyone I have an issue i have a spread sheet that has SKUs for products and another spread sheet that i am going to be using for updates on in stock values. My problem is i was going to use VLOOKUP to pull the value of the in stock qty but i can not do that because my SKU is not the...

Hi all I can't seem to find the right code for what I want to do. I've designed a very basic POS type system in excel for our shop: When a stock number is typed into column A, column B,C,D & E are populated using Index & Match formula. When I press the cash/card/cheque button, Excel copies the...

Hi all I'm not sure how to sum up the nature of my problem, sorry if the heading is confusing. I'll try to keep it as clear as possible. After some processes, I end up with several tables of data in a sheet in the following format: <tbody> Billy STAFF MEMBER STOCK NUMBER PRICE 1111...

Hello all, I am hoping someone can help me. I am looking for a way to highlight any orders that are put in to a sheet that take the requirement over the current stock, But only highlight those orders not the ones there is enough stock for. So in the example below Alice's order of code 123 would...

I would like to transpose columns to rows Please note that the spreadsheet is quite large. Current file layout example: <colgroup><col style="mso-width-source:userset;mso-width-alt:3035;width:62pt" width="83"> <col style="mso-width-source:userset;mso-width-alt:5668;width:116pt" width="155">...

Hi all, I would like to write a VBA code so that, to run through row “2” and where find the description “Item code” should prepare the formula below descriptions “Closing stock quant”: .Formula = "=VLOOKUP(RC[10],'[Closingstock.xlsx]Sheet1'!R4C1:R5000C32,25,0)" “Cons.quant”: .Formula =...

I have a sheet (made by some SQL/VBA/Excel expert long time ago). In this sheet I can enter a production run number ("Productieorder / PO") and it will show me all necessary components with current stock, clearance status, total needed stock etc. pulled form an insanely large database. I would...

Hello, The header is the advance filter, where I can select part number from the drop down, and below that is the data with part numbers and the remarks column showing excess and nil stock. When I select the part number in the header from the drop down, I want the NIL STOCK part numbers to...

Hi ya, I have been searching all through the forum but cannot get my head around Pivot Table calculated field, will be very appreciate of any help. I have raw data as following. I buy stock from different suppliers. Every item has a code. If I buy same stock from different suppliers, my code...

Hi all, i need to create a formula as per the below where you have a store with customer orders in column A, what is in stock in B, what they have soon to arrive at store in C and D is how many they are short. Column F is what stock is in the warehouse, and waiting to be transferred but due to...

Hello Friends, I have a code which gives the stock quotes in web browser. Is it possible to have list of 50 stocks from Indian Stock Market & have TO & From date columns. So whatever stock is selected from the list & respective dates, the data will be downloaded. Thanks In Advance AR

Hi, I am trying to get a set of results which are filtered based on the selection entered. I have a spreadsheet with a list of stock items etc, and these can be duplicated because they can be in different stores. I want to be able to filter my results based on the selection of stores So in...

Before withdraw on inventory monitoring page: <tbody> A B C D 1 Part Number Start Stock Qty In Stock Balance 2 123 10 8 3 456 20 7 4 789 30 6 5 101 40 5 </tbody> Withdrawing on inventory withdrawal page(different tab): <tbody> A B C D E 1 Date Withdraw Part Number Withdraw Qty...

I've created a company phone directory that is currently sorted by extensions. I'm trying to create a macro that sorted by their department. For example: <tbody> EXT. 1stNAME LastName DEPT 1234 Paul Smith Sales 4566 Meredith Jones Cook 2345 Shirley Grasse Sales 7624 Eddie Coleman Stock...

I want to create and print files with the following logic : file 1 : keep row 1 Id Account Asset Class Sub Asset Class Action Qty/Nominal Symbol Name ISIN Exchange Currency Last price at CRE Run Counterpart and add row 2 11814 30000 stock sell 28300 ATW ATWOOD OCEANICS INC US0500951084 US...

Hi, I have a spreadsheet with thousands of product codes, and corresponding data of stock on hand and weekly orders. I would like to match the product codes with each other to automatically align, in each row, the data of stock on hand and orders. For example column C has the product codes for...

Hello Guys, Searched net way too much and could not find solution to my problem. Will try to explain as clear as possible what I am trying to do. I tried to do simple weighbridge userform with simple stock control but I am stuck... Since I cannot add any photos, I will try to explain what I am...

Hi, I have an data as mentioned below, If the wanted is zero, then the cell should be empty else it should show the number. <colgroup><col><col><col></colgroup><tbody> Stock Available Wanted 6 5 1 5 5 0 </tbody> can any one help me in this. Thanks in advance.

Hello, I have 2 columns of dates. The first column has all of the dates in the year and the second has dates where the stock market was open, next to which are stock prices. I would like to have the stock prices appear next to the first column where the dates match and on days where there is no...

Hi, I would really appreciate some help with the above Currently, I have the following: Total Stock used The (project) Start Date Average Stock Usage per month is then calculated by using Total Stock Used / Months using DATEDIF (today's date minus start date) in months. This works fine but, to...