View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LindaR LindaR is offline
external usenet poster
 
Posts: 3
Default Comparing data in multiple spreadsheets with the first being t

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!