Finding Duplicates adding them to another sheet

[sentinela]

Hello everyone....

I have a project where I need items for different boxes.

i have 20 boxes that need the same amount of items. However, when I came towards the end, i ran out of items.
For example

BOX A IS MISSING
ITEM 1 AND 2

BOX B IS MISSING
ITEM 2 AND 5

BOX C IS MISSING
ITEM 1 AND 5

I have all in a spreadsheet all the items that are missing per box. Here comes the main question....
How do I program my spreadsheet find the items that are missing in each box and summarize in another sheet?

The summary I am looking for is....

ITEM 1 - 5 (MISSING)
ITEM 2 - 9 (MISSING)
and so on...

I started doing the code, but I haven't got too far.

Thanks in advance

[Leith Ross]

Hello sentinela,

It would be faster and easier to answer your question if you post your workbook. If your workbook is in 2007 format, you may want to post another copy in 2003 format also.

[sentinela]

Leith,

Thanks for your answer.

Here is my book. I appreciated the help.

[Leith Ross]

Hello sentinela,

You can do this using formulas. I used SUMIF on the Missing_Summary worksheet. I changed the names in column "A" to match the names on the other worksheet, i.e. "BLUE" to "BLUE PEN" etc. Here is the formula for "B6" on on Missing_Summary...

Please Login or Register  to view this content.

I did a fill down from B6 to B10. These changes are in the attached workbook.

[sentinela]

Leith,

I appreciated your help. That works great.

Thank you!