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" wrote in message
...
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