I need help to compare the salesvolume of identical products in two seperate worksheets

[Defron]

This is how my face looks like at the moment.

Situation:

Worksheet company A: Filled with products

Worksheet company B: Filled with products

Is there a way to copy/export the products from A&B into a new worksheet and compare the sales of these products to eachother?
I want to compare the salesvolumes of the products (of A&B).

Goal of this comparement: See if products need to be moved from A --> B or B --> A.

Hopefuly this is a simple question for some of you, and hopefuly there is a person who will take the time to answer my call...

Thanks in advance!!

Defron from the Netherlands

[PeteinSQ]

Are the products in sheet A the same ones as is sheet B? For example is it territory data? If it is you could use a vlookup to copy the sales value for the products in sheet B into sheet A and put them into an adjacent column. I don't know what comparison you're looking to make or what the criteria for inclusion in A or B is though.

[Defron]

Thanks for your reply!

The products are the same (except for a couple of extra products in store A = bigger warehouse).


I was working with Vlookup, i tried. My intention was to create a column in worksheet A, named: Sales B.
If I could fill in the sales in this column, i could subtract the sales of every product (sales A - sales B).

Then the subtracted amount will give me information where to move the inventory to.

I will try figuring the vlookup out. Thanks!