qty

i had one excel sheet .there is 6 column there quantity, recievd qnty ,,balance qty, rate ,tax 5%,and Discount in %. . i need last cell used all <colgroup><col><col span="2"><col><col><col span="2"><col span="10"><col span="2"><col span="2"><col><col><col...

I have a excel sheet having monthwise sales (qty and value) in column against each item in row. I need to sum the alternate column (i.e qty and value seperately). I am using the formula "=SUMPRODUCT(--(MOD(COLUMN(D4:AA4)-COLUMN(D4)+1,2)=0),D4:AA4 " which gives total of all the qty and value...

I am trying to see if there is a way to flag instances where a start date (Col E) is greater than that of a previous Machine Run. I have two items (29382 and 9384). The projected stock column is adding the machine run qty to current stock in the following machine run to I can see how much I will...

hi, I have multiple suppliers that I ask them to supply plumbing items that I choose at their best price. My trouble is the suppliers are becoming more eg. 10 suppliers. Each supplier can supply their 'own brand' of tap or Pipe Each supplier may have a different QTY for what they are...

I have a sheet where I am trying to pull only the cell where the value is greater the 3 and put them in column H & I within the same sheet. I have a list in Table 1 where if "F" is > the 3 with conditional formatting on. Is there a way to pull only data from Table 1 with Qty > then 3 and match...

SHEET 1 <tbody> A B C D E F G H I J K 1 FRUIT OTHER 2 NAME QTY PRICE NAME QTY PRICE NAME QTY PRICE 3 APPLE 2 100 4 PINEAPPLE 1 150 5 BAG 3 300 6 BANANA 2 200 7 PENCIL 1 50 8...

Hello I have a table that have IDs with the same Code And Qty . For Example in row 1 of table , IDs from 200 to 210 have 9461626177 Code and 1000 Qty I need a loop to get lower and upper value from cell ( Column C and D ) and copy to new table for all tale rows ( till first blank row of...

Hello, I currently use find and replace in my macro, but I am needing to replace one kit# with the two components. The second item would be 2x the qty of the original kit qty. Id need to replace "bracket-kit" with "bracket," and add a second line for "bolts." The bracket line can simply...

Hi, I need help figuring out the formula for the following case, I need to keep track of my inventory so I have a base inventory to wich I need to add the quantity of what is produced in a day and substract the amount of what is sold that same day. Inventory table <tbody> Code Name Qty On...

Hi there, I get this horrible inventory sheet from this company. Same inventory sheet every week. It has 5 tabs, but I need to combine it into one tab so I can run my vlookup. Is there a good way using "get and transform" or something else that can combine the worksheets every week? I only...

Hello, We currently use a Excel doc with about 50 sheets, each representing a different box that is shipped/loaned frequently and needs to be rechecked often to confirm it has it's full inventory. Line items(rows) are also often added/removed to each box. The desired amount of item X is always...

Hi, I am trying to create an inventory spreadsheet where usage removes quantities from a lot until it is completely relieved and then the next lot is subtracted from. I have completed this as below: <colgroup><col><col><col span="2"><col><col><col></colgroup><tbody> Lot Date Received Qty...

As per title, can anyone teach me how to formulating the "SUMIFS" for different product qty in monthly basis? I used below formula to obtain the monthly "In" & "Out" qty of each items, but it seems not working perfectly. =SUMIFS('Daily Inventory Record-FE01'!$D$6:D66900,'Daily Inventory...

Hi guys, does anyone know how to get the accumulative sum for same product type and name within a list? <colgroup><col><col><col><col><col span="2"></colgroup><tbody> <colgroup><col><col><col><col><col span="2"></colgroup><tbody> Entry Date Product Type Product Name In Out Bal Qty...

Need report on Column A which are cust ID that list down week no x qty in 2 columns only Header Row 1 are week no, (Row can be dynamic too) Value are ETA qty, (if can select qty or "tbc", empty cell are ignored too) Thank to advised the vba method Initial <tbody> Cust ID / Week w01 w02 w03...

Hello All, One of my vendors that sell Tree's & Plants sent me a price list which is about 10,000 lines long. I use this for quoting. What I would like to do is have a QTY column. I search for the item and enter in a number in the QTY, then I would like to copy this entire line to Sheet B...

Hello to all, I am trying to use running total in pivot table. I have typed the columns below that work, but when I add the info columns I need running total stops working. Base field is set to Date of Movement. This works: A B C D...

This is what I had in another workbook <tbody> Part Number Description RV QTY Heat Line Reason Stamp 1139395 Housing 3 Shrink 1139395 Housing 2 Slag 1138395 Cap 4 Dirt </tbody> and below that <tbody> Part Number Pin Holes Shrink Slag Cold Seam Dirt Filter 1133915 0 0 0 0...

I have a software that exports its reports in tab delimited format, i have 26 of those to open in excel and i'm opening it individually, doing up the individual tab delimiting msgs, then moving each sheet to one workbook to combine them. - surely there must be an easier way to do all that! any...

Hi, I have created a April 2018 workbook for a production project; each tab representing a day of the month; in this case, Mon 2-Mon 30. On each day I have an identical layout/formulas. I used drop down lists so the operator can select various programs they are working on and actual pieces...