comparing from two worksheets

[Lorne]

Hi all, I am trying to compare from two worksheets. What I have is the
inventory that my headoffice is telling me I have and the other is the actual
inventory I have I want to compare the two by product number and discription
giving the head office total per item, my total per item and the difference
between the two. I have a general knowledge about this but I thinking its
over my head. Help required. Thanks

 

[Otto Moehrbach]

Lorne
I can help you with that but I need to know all the details about the
layout of both sheets, that is, what's in what column, what's in what row,
where are the headers if any, where does the data start. You say you want
to compare by product number AND description. Do you mean that your data
has more than one description per product number or maybe more than one
product number per description? Clarify that point.
Do you want the result (head office total per item, my total per item and
the difference between the two) on a separate sheet? Otto

 

[Lorne]

Otto,
each colum has
Size Item Description Total Issued JVD Forecast Remaining to order
Surplus
10.0 KNIFE GATE 0 1
1 0

In general Head offices orders what they think I need which is the total
issued, I am forcasting we are going to need so many for different locations.
My inventory is based on a physical count. My boss want to see the
relationship of what is ordered to what is needed to order per location. Yes
i guess I am looking to give him a report of my inventory to head offices
inventory and show the difference between the two on a seperated sheet. I
have only started woking with pivot tables the last week. What is more is
that my spreadsheet has product that the head office does not have on there
list. Is this kind of clear? I also have more heading then this that I am
able to sort by

Total issued: Head office
Forcast: me
Remaining to order: Head office
Surplus is me

 

[Otto Moehrbach]

Lorne
I think I need to see what you have and what you want. If you feel some
or all of your data is proprietary, fabricate a bunch of data. I need just
the layout of it all. Also include the final product sheet that you want
with a few examples of the final product. Again, I need just the layout.
Make sure that the final product data is generated from the data on the
other 2 sheets so that I can get the flow of what you want. My email is
(e-mail address removed). Remove the "extra" from this address. Otto

 

[Lorne]

Otto,
Thanks Will do.

Lorne
I think I need to see what you have and what you want. If you feel some
or all of your data is proprietary, fabricate a bunch of data. I need just
the layout of it all. Also include the final product sheet that you want
with a few examples of the final product. Again, I need just the layout.
Make sure that the final product data is generated from the data on the
other 2 sheets so that I can get the flow of what you want. My email is
(e-mail address removed). Remove the "extra" from this address. Otto