Cosolidation and Crossmatching of Data

[odie]

Hi dear Gurus of Excel,

I have a situation @ work and is trying to come up with some kinda of method using Excel to solve it.

Situation:
I have a master database which are unique items with an initial quantity vs the item.

This list has to be crossmatched every month against the current existing stock which individual items might be duplicated.

Then, it has to display the items which are sold from initial stock. They also should not display items which are same as initial qty.

I have attached an example..... *Duplication Test.xls*

Basically, "Initial Master Database" is my initial inventory. The items are barcodes (Ean-13 which i can treat as strict text strings) vs QTY.

"March 2009 Balance Stock" is an example of a typical month's balance stocks, which can be all over the place, hence multiple entries.

"Sold" is what i have to display.

Could someone please enlighten me?

PS: In real life, that list is about hmmm.... 6000-7000 unique barcodes.

PS2: I need help with :
a) Data consolidation on the every month's new data.
b) A crossmatch help between this new data list (consolidated) vs the initial.
c) A display of the difference in the quantity on a new worksheet perhaps.

==========

Eh.... hi royUK,

I am new to this forum. Not too sure what that meant.....

Probably title:
"How do I consolidate data and do a crossmatching on Excel data"

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[ConneXionLost]

Is this what you mean?

I didn't know what the coloured text on the "Sold" worksheet represented, so I left it out.

[odie]

Hi ConneXionLost,

Oh! WOW! That was amazing! Thanks! Let me test the data with my account's colleague and i see if that works! Thanks! :D