Compare 2 spreadsheets

  • Thread starter Thread starter tonior
  • Start date Start date
T

tonior

I have a product order template of approx. 230 line
items. I receive new orders that should follow the
template, but don't always. Sometimes they may be missing
a few items. It can be time consuming to go through every
order. Does anyone know a way to compare the new order to
the order template, to see if they left anything off.
Both spreadsheets have, in seperate columns, sku#, part#,
item description, and order quantity.
Thank you.
 
Since I have not received any responses, I think maybe I
didn't include enough information, or was not clear about
my goal.
What I am trying to do is to be able to compare the
information in the part# column of the second sheet to
the part# column in the first sheet. If there are any
missing from the second sheet, I would like the missing
part# highlighted on the second sheet. I would really
appreciate if someone could help me with this.
Thank you,
tonior
 
Hi Tonior...........

I did not respond sooner, because I was waiting to see if you received some
solutions, and did not want to tout a commerical product. However, if you
still do not receive any answers, and are needy enough to be interested in
a commercial solution, send me an email request and I will provide the name
and addy of the commercial Add-in that I use for similar tasks. I can't
guarantee it will exactly fill your needs, but it is about "comparisons"
and you can check it out for yourself and see if it will help.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top