Add Missing Items to List

[kevin_w90]

Hello,

I have a list of batch numbers (column A) along with the item number for the batch (column B) and a list of what ingredients were used in the batch (column C). I then have on sheet 2 a standard ingredient list for each item which has item in column A and then a list of ingredients in column B. I need to check the batches on sheet 1 against the standard list on sheet 2 to see if any ingredients have been removed from the original standard and add a row for each missing ingredient on sheet 1 for each batch.

Thanks

 

[oldbrewer]

it seems the batch number is irrelevant, is this so ?

 

[kevin_w90]

Hi oldbrewer,

I've attached a link where I've explained it better along with a sample workbook. Any help would be greatly appreciated.

Thanks

http://www.ozgrid.com/forum/showthread.php?t=205584

 

[Joe4]

I've attached a link where I've explained it better along with a sample workbook. Any help would be greatly appreciated.

Yes, if you are going to Cross-Post your questions, be sure to mention you are doing so, and provide links, as is explained in rule 13 here: https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[kevin_w90]

Apologies Joe, never realized. I'll ensure both posted get updated if my problem gets solved on either.

Thanks