production report update from packing report.

dear friends i want to update my first sheet from second sheet.second sheet our packing report & it's daily I'm getting from packing department.according to packing report i want to update production sheet.second sheet Column "F" first 6 characters i need to mach with first sheet column "K" first 6 characters.if it is match then first sheet column "J" values need to reduce form second sheet column "G".
ex- first sheet value = 60
packing report value = 50 then answer in first sheet column "J" =60-50 = 10
after updating first sheet column "J" any value coming mines then that row need to delete.
pls make macro for this.thanks..

This should do it:

Please Login or Register  to view this content.

This might be what you need.

Please Login or Register  to view this content.

dear JB thanks u very much for your helps.i have two problems.one is below code giving some error.other one is both sheet values are equals then first sheet that row also need to delete.i mean after minus first reports values from second sheet values answers are zero or minus then that all rows should delete,

Please Login or Register  to view this content.

Here's the update to delete the PRODUCTION row if the value drops to zero or below:

Please Login or Register  to view this content.

dear JB everything work very well.just one adjustment i need.some values u reducing form first sheet column "K" that values can i see,i mean not final answer.if i click that cell it should below example.then i can understand how much packed & how much balance to pack.
ex- =4500-500

Um.........huh?

If I can do what?

My reply to your post #7 is summed up in post #8.

Ah...the lights have got on. Now I see what you mean. Nice work, John!

Maybe like this:

Please Login or Register  to view this content.