I have two different worksheets with more or less the same data in relevent
columns, what I want to do is verify data within certain columns. how can I
do this to show any difference
I have two different worksheets with more or less the same data in relevent
columns, what I want to do is verify data within certain columns. how can I
do this to show any difference
There are at least a couple of alternatives. One is to create an extra
column in each worksheet identifying which worksheet the data belongs to and
then combining the two worksheets into one. You could then sort the
combined worksheet so that matching rows from the two worksheets are next to
one another. Finally, you could write a macro to do a comparison of the
rows and check appropriate values. It is a bit complicated, but it can be
done.
A second option is to link the two worksheets into Access and do a join
query on the relevant fields to find the matching and non-matching rows
between the two worksheets. This is the easier option in my opinion,
however it requires knowledge of Access, of course.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
"data verification" <data [email protected]> wrote in
message news:[email protected]...
I have two different worksheets with more or less the same data in relevent
columns, what I want to do is verify data within certain columns. how can I
do this to show any difference
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks