Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

5
  • 1
    Have you considered using ADO and writing a SQL statement, e.g. a join? Should be pretty quick. Commented Jul 28, 2016 at 20:21
  • No, I actually have no idea about that... any other ways? Commented Jul 28, 2016 at 20:32
  • Loops can be fast enough - you don't have that much data. Commented Jul 28, 2016 at 23:29
  • Possible duplicate of What is the most efficient/quickest way to loop through rows in VBA (excel)? Commented Jul 29, 2016 at 7:51
  • What do you mean by "make sure all fields match"? Do you have columns in both tables that must have the same value (if same PK)? Are those fields in the same column in both tables? If so you could merge the tables in a new sheet and remove duplicates and then there should only be unique PKs left. Commented Jul 29, 2016 at 10:26