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!