title: VBA - Compare Tables on 2 Sheets with Differences
body: <p>I am new to VBA and was looking for help in writing a sub or code that can compare the same column (B) of two tables on 2 different sheets and combine them into a single table on the first sheet. I have looked at ways to do it and am really confused about using ranges or unions as a solution. I want it to find items both missing from column b in sheet 2 (which will have a dynamic, but known name stored in a variable) and add that entire row to sheet 1 (named 'Dump' with an additional comment on column d, as well as check for rows present in 'Dump' but not present in the other sheet. It only needs to compare column b of the two sheets as column b is the key.</p>
  
  <p>Here's an example of what I am looking for given 2 sheets of data, and the final output.</p>
  
  <pre><code>**Sheet 'Dump'**
  +---------------------------+-----+------------------+---+
  |             A             |  B  |        C         | D |
  +---------------------------+-----+------------------+---+
  | v62: Cheetah Mail         | v62 | 206              |   |
  | c49: Report Suite         | c49 | appid            |   |
  | v75: Message Type         | v75 | NDS Error        |   |
  | v42: Core                 | v42 | fd8000d7         |   |
  | c37: Message Key          | c37 | fd8000d7         |   |
  +---------------------------+-----+------------------+---+
  
  **Sheet 'ICD'**
  +---------------------------+-----+-----------+---+
  |             A             |  B  |     C     | D |
  +---------------------------+-----+-----------+---+
  | v62: Cheetah Mail         | v62 | 206       |   |
  | c44: Portal               | c44 | polo      |   |
  | v75: Message Type         | v75 | NDS Error |   |
  | v42: Core                 | v42 | fd8000d7  |   |
  | c37: Message Key          | c37 | fd8000d7  |   |
  +---------------------------+-----+-----------+---+
  
  Output Sheet 'Dump'
  +--------------------+-----+-----------+---------------------------------------+
  |         A          |  B  |     C     |                   D                   |
  +--------------------+-----+-----------+---------------------------------------+
  | v62: Cheetah Mail  | v62 | 206       |                                       |
  | c44: Portal        | c44 | polo      | Item found in "ICD" but not in "Dump" |
  | c49: Report Suite  | c49 | appid     | Item found in "Dump" but not in "ICD" |
  | v75: Message Type  | v75 | NDS Error |                                       |
  | v42: Core          | v42 | fd8000d7  |                                       |
  | c37: Message Key   | c37 | fd8000d7  |                                       |
  +--------------------+-----+-----------+---------------------------------------+
  </code></pre>
  
  <p>It doesn't matter where the row is placed as it will be sorted later. Thank you so much for the help</p>