qty

The following code has worked before, but now it doesn't and I can't figure out why. I just determine the value in the activecell and if it's more than one I just copy the row and insert it below the selected row, but for some reason I get a runtime error 1004 and the insert method fails. I...

<tbody> Finish Product code Finish Item Qty 2001 Burger 2 2002 Caffe tea 3 </tbody> <tbody> Finish Product Code Raw Material Code Raw material item Qty Sub Qty 2001 1001 Salat 0.2 ? 2001 1002 Sugar 1 ? 2002 1003 Caffe 0.7 ? 2002 1001 Water 0.9 ? 2002 1003 Tea 0.2 ? </tbody> MY...

Hi Could really do with some assistance on this one ...svp Table below . . . to achieve 16000 in A3 I've calc'd as follows; =$B3*((D3*E3)+(F3*G3)+(H3*I3)+(J3*K3)+(L3*M3)) ... this works but is 'long-hand' and doesn't address the rate changes in columns B & C. Does anyone know a way of using...

Hi I am creating an excel where in 1 sheet I will take lets say the order: i.e: Date, Customer Name, Product Code, Qty and on the sheet 2 I will have on the A column all the products and on A2, A3,A4, A5 .. all the customers. What I want to do is to be possible the Sheet 2 to read from Sheet 1...

Hi All, We are collecting spare sale information using Microsoft, data is getting accumulated as Spare code 1 – Spare code 1 Qty , Spare code 2 – Spare code 2 Qty , Spare code 3 – Spare code 3 Qty , Spare code 4 – Spare code 4 Qty . Now we want to compile the file as ASC name , spares list...

Morning, For the life of me i can not think of a way to do this. So im trying to set up a spreadsheet for inventory management. I have the following formula in cell E2 =IF([Average_Qty per week]>=3,[@[Average_Qty per week]]*D$1,(D$1/2)*[Average_Qty per week]) But i would like this to have...

Trying to minimize leftovers to be as close as possible to 0 but not negative by shifting inventories around Inventory qty can only move horizontally (i.e., Inventory 1 can't move to inventory 2 or 3) Inventory qty is already given, each qty is treated as a whole and can't be combined or merged...

hello all, so i have a few excel sheets that have information on them. each excel sheet is an purchase order. in them it has all item information with sku cases QTY unit QTY and pricing and more. so i have a few excel sheets each one is a diffrent order for a diffrent factory. what i want to do...

To simplify here is what I'm trying to do From this: To this: Move inventory 1 to 5 to the next month and ensure that leftovers is as close as possible to 0 but not go negative. The inventory Qty is treated as a whole and can't be combined Previous month's inventory takes priority and it can...

Good Morning, I'm new to the forum and trying to brush up on my Excel skills to improve efficiencies with my daily work tasks. I'm just starting to learn about multiple if / if and statements to save me creating extra columns etc I'm using a tick box to give a true/false value, if the box...

Hi all, I try to find the lines of code that would allow me to put the right up connector to a cell Here you can see what I have https://www.dropbox.com/s/95uvji7ageuumy9/Connector%20flaw.png?dl=0 and what I would like https://www.dropbox.com/s/c49g3t9v9xzlhf2/connector%20proper.png?dl=0...

hi guys a i am trying to count the number of customers that have both product AR and SR and what is the combined QTY so for example i want something like this Product combo combined qty number of customer AR&SR 67 2 below is the...

I have 2 sheets . One that shows me a part number description and qty on open orders at I have through a pivot table . I have another sheet for my inventory that shows Part number description and on hand qty. I want to do a vlookup on the open orders to show me how many I have on hand to fill...

Hi, I'm have a large data set and am trying to identify a formula that will make a calculation based on the sequence number. Example below. From a lookup I have identified that a quantity of 3 are packed, but I want the 3 to be deducted from the first schedule line only, and if the schedule...

Hello All, good day. I have excel file in the below format. Sheet Name :- Sheet1 <tbody> QTY Data Value Solution QTY Data Value 1 TSK desc1 1 TSK desc1 2 ASD DESC201 1 ASD DESC201 1 ASDF des30 1 ASD DESC201...

hello All . i have a question i have a table with name po and qty and lot i need result lot how like i post image in image i give fist lot until his lot vale equal or grater then his total then pick next lot until his balance equal and grater then to qty ...

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...

I have been searching most of this morning looking for a solution. I have not seen anything like what I am wanting to do. I have a Bill Of Materials with a part number, Description, Cost, and QTY. Some of those rows do not list an item, so I don't want those copied. Just the cells that have a...

Hello All, Info: I've created a spreadsheet that filter data from and inventory list to 2 other sheets one titled "low" and the other titled "out of service" when the "actual qty" falls bellow the "req qty" in the inventory list it's filtered to the "low" sheet. When the "req qty" turns to...

This is a re-post from another site, since I wasn't having much luck on there: The problem I'm presenting's a little above my VBA skills, so I appreciate any help and ideas. I've pasted a couple of excel sheets to give a general idea of what I'm looking for. Essentially I'm looking for a code...