Compare two arrays

Posted on 2006-07-06
Last Modified: 2010-04-30
I have two arrays filled with inventory part numbers and pricing information.

Dim existing400(2000, 4)  ~600 items
Dim New400(2000, 3)      ~1200 items

existing400(1,1) 'part number
existing400(1,2) 'Item description
existing400(1,3) 'unit price
existing400(1,4) 'unit price from "New400" array

new400(1,1) 'part number
new400(1,2) 'Item description
new400(1,3) 'unit price

What I am looking to accomplish is to fill the first array(existing400(1,4)) with the current pricing from the second array(new400).  

I need ideas on how to set this up.

Question by:RobertStamm
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 13

Accepted Solution

rettiseert earned 250 total points
ID: 17051040
Try this:

    Dim I As Long, J As Long
    For I = LBound(existing400) To UBound(existing400)
        For J = LBound(New400) To UBound(New400)
            If existing400(I, 1) = New400(J, 1) Then
                existing400(1, 4) = New400(1, 3)
            End If

Author Comment

ID: 17051292
Found a opps but I was able to fix it.  

existing400(1, 4) = New400(1, 3)
Should have been.
existing400(I, 4) = New400(J, 3)

Works great.
Thank you.
LVL 13

Expert Comment

ID: 17051485
yes, a little mistake : )

also, you would like to add a
exit for
after the existing400(I, 4) = New400(J, 3) line

Author Comment

ID: 17051548

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Adding to a VBA? 6 90
passing a value with stream reader AFTER a ";" 3 91
TT Auto Dashboard 13 104
I need help embedding an image as HTML in my application 3 84
Introduction While answering a recent question ( in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question