From: vas on 24 Dec 2009 05:11 Hi The equation if item_a=stockitem_a (stockqty_a=stockqty_a-itemqty_a) else if item_b=stockitem_b (stockqty_b=stockqty_b-itemqty_b) .... but more than 7 nested loops are not applicable. so please suggest. .... when i enter an item, the stock should be reduced by the quantity and whn i enter the same item quantity again then stock should be reduced from the remaining quantity. how will i do that... eg item a is entered twice 1st 12 quantity, so the stock should be 2 and i entered a again in the last 1quantity. so the remaining stock should be 1 Date Item Qty 1-Jan a 12 4-Mar b 13 4-May c 14 7-Sep d 15 8-Mar e 16 9-Aug f 17 12-Dec g 17 Item Stock a 14 b 15 c 16 d 17 e 18 f 19 g 19 Waiting for the suggestions. we cannot use the more than 7 nested loops. waiting for the solution with thanks From: Don Guillett on 24 Dec 2009 11:07 If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1(a)austin.rr.com "vas" wrote in message news:ADFDD056-7A02-481B-854D-3D2D4A457E26(a)microsoft.com...> Hi > > The equation > > if item_a=stockitem_a > (stockqty_a=stockqty_a-itemqty_a) > else if item_b=stockitem_b > (stockqty_b=stockqty_b-itemqty_b) > ... > but more than 7 nested loops are not applicable. so please suggest. > ... > when i enter an item, the stock should be reduced by the quantity and whn > i > enter the same item quantity again then stock should be reduced from the > remaining quantity. how will i do that... > eg item a is entered twice 1st 12 > quantity, so the stock should be 2 and i entered a again in the last > 1quantity. so the remaining stock should be 1 > > Date Item Qty > 1-Jan a 12 > 4-Mar b 13 > 4-May c 14 > 7-Sep d 15 > 8-Mar e 16 > 9-Aug f 17 > 12-Dec g 17 > > Item Stock > a 14 > b 15 > c 16 > d 17 > e 18 > f 19 > g 19 > > > > Waiting for the suggestions. we cannot use the more than 7 nested loops. > waiting for the solution with thanks  |  Pages: 1 Prev: How can I solve this.Next: adding every other column