quantity

I have a “Master Parts List” sheet where Part Numbers start in A2 and Part Description starting in B2. I have ~ 25 Sheets each with a different name where there are columns in each. I want to match the Part Number & Description to the Master Part List and sum the total Quantity of parts from...

Hello, I have to review a reconciliation file similar to the one below. The problem is that in column 5 (Comment) there could be cells that include a number of items, which makes it impossible for me to filter/analyse the data, (i.e. comments for item #3 ). Whenever a comment contains several...

I have column F10 where i have the "Quantity", in each cell, I have a number + cases or each or lbs, or Cases. I want to remove the words, just keep the number. Any help, scripts are welcome. Thank you <tbody> Quantity 1 Cases 1 cases 11 lbs 3 each </tbody>

I have an order form where I have over 1000 items. I want the output on Sheet2 to only provide the quantity and Item Code Sheet1 Source " Item Code " K16:K999 Quantity C16:C999 Results on Sheet2 Any assistance would be great.

HELLO, I HAVE A WORKSHEET THAT LOOKS SOMETHING LIKE THIS... <tbody> QUANTITY PART # 4 A 2 C 1 B 3 A 1 A 2 B 5 C </tbody> I AM LOOKING FOR A VBA TO SORT AND FILTER THE TABLE TO LOOK LIKE ... <tbody> QUANTITY PART # 4 A 3 A 1 A 8 TOTAL 1 B...

I'm trying to write a formula that will add "500" to the adjacent cell quantity, like this =IF(D3:D100>0,D3:D100+500,"") It's working but I'm getting an error. Please help!

Hello all! First time posting in this wonderful forum! I have a workbook where I enter our few departments weekly sales by Customer name, Item number, amount and quantity. I have tried to make things little bit more smooth and faster so I create a new workbook with two sheets. Please find...

Help I have a spreadsheet with an inventory table on sheet2. It's a 104RX5C table named Inventory and so is the sheet with the following columns: and <tbody> Family Model Volume PartNumber Quantity </tbody> On Sheet1 "Data Entry " i have a Userform that has 3 comboboxes corresponding to...

Hello - I want to be able to in power query to take a list of records and create new copys of each record based on a quantity column. As a example, I provided a few fields, but I will like for it to copy the entire row as I have 20+ columns. Current Result Item Quantity 1234 2 5678...

I am looking for a solution to the following: user selects a quantity of various product from sheet 1. Sheet 2 then lists the quantity and product down columns A & B based on the selection of Sheet A. Once that order is completed it continues to save the next order on the next available...

Hello All, I was wondering if anyone could help me with this. I've been trying to figure it out for days now, but just can't. below I have a code which allows me to change the value in a cell with a double click. I can do this in any cell in the worksheet. the problem is, I only want to be...

Hello to everyone. I have this situation (products / quantity / year) In column "I" i want to put quantity for these products which corresponding with year 2018 (cell "M2") Thansk's <tbody> A B B D E F G H I J K L M N O Products Quantity [kg] Year 00000 00000 000 0000 Products Qnty [kg]...

I've got a table with the following columns Quantity, Price, Sub Total, Discount Tier, Discount Amount, Total If the quantity is between 100 and 200 I want to show a 5% discount in the Discount Tier column If the quantity is between 201 and 300 I want to show a 7% discount in the Discount...

Hi all, I have a problem that I just can't figure out. I'm building a Excel tool that will provide a suggested order quantity to purchase per SKU. It has a lot of formula with which i'm happy (forecast, safety stock, re order points, frequency, etc), however there is 1 that I just can't seem to...

Hi all, I'm having difficulty calculating breakeven quantity through an Excel formula and I was wondering if one of the genius can help me figure it out. Below are my costs: <colgroup><col><col></colgroup><tbody> Sales 9,000,000 Cogs 7,813,800 Direct Cost 896,139 Indirect Cost 617,916...

I have working formulas to pull data and price from database per upc code that has been scanned and entered into the cell. What is happenning is when i scan a barcode more than once i have multiple lines with the same information. What i would like for excel to do is instead of having multiple...

Hey community, I need formula to show TOP 10 smallest values with their names ( Cell A1:A119 contains names of products and B1:B119 quantity of products ) Note: some products got same quantity

I have a form on sheet 1 where only selective date is entered onto sheet 2. However, on Sheet 2 I have Row 1 columns filled from A:BCL with numbers. On Sheet 2 what I need is The account number from sheet 1 (simple) and the quantity selected of a product selected from sheet 1...

I am trying to write a formula that will do the following: I have a total quantity that is given in cell G30. I also have a total quantity that is in cell E29. I need a formula that says if G30 is greater than E29, use the E29. Any help would be much appreciated. Thanks!

Hi All, I have the below data set, and the problem is that quantity and value is dumped by columns, and there are around 50 columns of quantity and value by each store. How can I arrange this in a tabular format and summarize by store / category with quantity and value. I have to select each...