Linda
I haven't heard back from you. If you want to work this through the
newsgroup, just give me the info I asked for and we'll do that. Otto
"LindaR" wrote in message
...
Otto,

Okay I will try and make this easy to understand without taking up too
much
space. I have a master spreadsheet of my inventory, column A is the phone
number and column B is the user name. Each month I get a new spreadsheet
with
the current users, so some have been added and some have been canceled.
Right
now what I do is sort both spreadsheets by the phone number, put the
master
and the current list in "side by side" view, then I scroll down through
both
of the sheets one line at a time to find the ones that are either new (not
on
the master) or "gone" from the list (still on the master but not on the
current bill). I have 4 different vendors to work through and 2 of the
spreadsheets has anywhere from 1200 to 1450 rows of data.

Thank you for your assistance. Linda

"Otto Moehrbach" wrote:

Linda
From what you say, you will probably need VBA programming for this.
You
will have to provide a lot more information about what you have and what
you
want to have. A good way to do this would be for you to write down a
step-by-step procedure of what you would do if you had to do this in
Excel
manually, that is, without programming. Include information about the
layout of what you have and what you want to have. Like, this is in this
column, that is in that column, etc. Explain it like you would for
someone
who knows nothing about your project. HTH Otto
"LindaR" wrote in message
...
I have been tasked with creating an inventory of all my wireless
devices. I
have a master started, but I get the monthly data on a spreadsheet from
multiple sources. I know there is a way to preserve my master inventory
and
compare the new monthly data to show anything that is either added or
deleted, but I am only a "basic" Excel user and would like to know how
to
do
this. Thanks!