packing update macro

[johncena]

Hi, here i have attached my sample sheet. first sheet is our company pending order list as per customer wise & send sheet is our daily production. different customers are requesting some times same product. but we are producing batch wise all together. in daily production sheet( sheet 2) column "A" has product name & column "G" has quantity. in pending order sheet(sheet 1) column "D" has same product name & column "J" has order quantity. so want is second sheet column "A" need to match with first sheet "D". if that values are matched then first sheet matching data rows need to delete base on second sheet column "G" value & first sheet column "J".

ex- one product produce 540 & same product available in first sheet two places 100 & 250 then that both rows should delete( because produced more than order quantity's). if produce 540 & first sheet available 300 & 400 then first 300 row should delete & second 400 value should change to 160 (400-240)(because produced less than order quantity's).

pls give me macro to do this, thanks in advance..

[ragulduy]

Please Login or Register  to view this content.

I think

[johncena]

Please Login or Register  to view this content.

I think

thanks a lot fro your code, if produce more than order quantity's your code work fine. if order quantity are more & production is less then your code calculation is wrong.

ex- produce 500 & first sheet available one place 520 & other place 300, then answer should be first 520 should change first 520 to 20 & other 300 should not change. pls help me..

[ragulduy]

Try this:

Please Login or Register  to view this content.

[nilem]

as an option
rows that need to be removed are highlighted in orange, and rows where the amount is reduced, highlighted in green

Please Login or Register  to view this content.

[johncena]

Try this:

Please Login or Register  to view this content.

sorry friend your code running without any error. but nothing happened. before code work fine but one result wrong. this not change anything..

[johncena]

as an option
rows that need to be removed are highlighted in orange, and rows where the amount is reduced, highlighted in green

Please Login or Register  to view this content.

thanks for your code. i want to remove complete data rows in first sheet. thanks..

[ragulduy]

One more try:

Please Login or Register  to view this content.

[nilem]

Hi Johncena,
try

Please Login or Register  to view this content.